What it is not
It is not another database GUI. The CrescoDB dashboard already exists and is better at that, which is why the extension opens it in your browser rather than trying to rebuild it in a panel.
What it does
- Runs the access audit on save and puts each finding as a squiggle on the line that caused it, with the reason in the hover.
- Offers a fix on the lightbulb. Lock a table to signed-in users, scope rows to their owner, or correct a role name that is not real.
- Shows a shield in the status bar with the count of critical findings.
- Shows your schema as a tree, with a lock icon for private tables and an open lock for public ones.
- Connects your AI agent in one click, writing the MCP config for whichever client you use and preserving any servers already in that file.
- Autocompletes schema.cresco from a JSON schema, so field types and access keys are suggested as you type.
It runs the same audit that cresco deploy runs. There is one implementation, so the editor and the deploy can never disagree with each other.
Installing
Search CrescoDB in the extensions panel, or install from the command line:
$ code --install-extension CrescoDB.crescodb
It is on the VS Code Marketplace and on Open VSX, so Cursor, Windsurf and VSCodium get it too.
Two things to know first
- Install the CLI first. The extension drives cresco under the hood. If it is not on your PATH, set crescodb.cliPath in settings.
- It only activates in a CrescoDB project, meaning a folder containing schema.cresco. Open a folder without one and you will correctly see nothing.