Documentation

What DataGripe does, how to run it, and where everything is hidden.

DataGripe is a database IDE for PostgreSQL, MySQL, SQLite and Redis that reads your queries and your schema back to you and says what is wrong with them. It runs as a web app you host, a desktop app you install, or one command on your own machine.

Every page is in the sidebar, and in the menu on the bar above on a narrow screen. This page is for working out which one you want.

I want to try it

Getting started is about twenty seconds and needs nothing installed. After that, the rules are what the whole thing is for — the 18 things it complains about, and none of them are formatting.

The two shortcuts nobody finds on their own are on the keyboard page, and they are worth thirty seconds: Ctrl/Cmd+Enter runs the statement the caret is in without selecting it, and Ctrl+Alt+L reformats.

I want to run it for other people

Start at deploying, which is the four shapes and how to pick one, then the page for whichever you picked.

Two settings decide whether a deployment works at all and neither has a default that can be right everywhere — WEB_ORIGIN and CONNECTION_ENCRYPTION_KEY. Both are on configuration, which is also where the rest of the environment lives, a page per decision: accounts and sign-in — including Google — database and storage, datasources, limits, files, git and commands and MCP. Security is what to change before it faces anybody.

I want to know why it is like this

Why it complains is the one sentence the whole gripes feature follows from, and what it costs. From there: gripe levels for the four-level dial, dismissing gripes for turning one off, and writing a rule for adding one.

The FAQ has the questions that come back, including the ones with an answer nobody likes, and the glossary has the words this project uses in a particular way.

I want to know what is missing

The roadmap is the gripes DataGripe has about itself, in the same voice it uses on your schema — accepted, unscheduled, unfiled, and the ones deliberately declined, which stay on the page because the reason something was refused is the useful part. Release notes are what has already shipped.

I am an agent

Every page here is also Markdown: append .md to the path instead of the trailing slash, so this page is /docs.md and the rules are /rules.md. No scraping and no JavaScript required.

DataGripe itself speaks MCP: a project can expose an endpoint an agent connects to, off until an owner turns it on and read-only until they say otherwise, with every call in the query history under the token's name.

Something is wrong

The app tells you what it refused and why, and the two settings that break a deployment most often are described where they are set. If a gripe is wrong, that is a bug worth reporting — a wrong gripe costs more trust than a missing one.

I am building it, not using it

The specifications are the other half of this site: twenty documents, one per subsystem, recording what each does, what it deliberately does not, and which alternatives were rejected and why. They are engineering documents and read like it.

The rest of the repository's docs/ holds the ADRs and the brand system, and roadmap.md is where the roadmap page is rendered from.

This page as Markdown, for an agent or a diff.