NexQLMCP

Docs

The map of everything NexQL does.

NexQL MCP gives your AI assistant 55 tools for your Postgres database, plus the guardrails that decide what they're allowed to do. Read a guide to understand a feature, or open a tool to see exactly how it behaves.

New here?Take the guided tourInstall, connect and ask your first question in about five minutes.Curious?How a question travelsFrom your words to rows, and every check in between.Looking for one?Search all 55 toolsFilter by name, task or access mode.

One question, four stops

  1. 01You ask“Which customers churned last month?”
  2. 02Your AI appPicks tools: search_schema, then run_select.
  3. 03nexql-mcp, on your computerFinds the real tables in its schema index, checks the SQL is allowed, masks personal data.
  4. 04Your databaseRuns the query read-only, under a time limit and a row cap.

Follow the whole route →

Tools, by line

Grouped by what you'd use them for. All but seven work in the default read-only mode; those seven, on the Changes line, need write or admin mode.

Explore the schema

Find the right tables before any SQL is written, so the assistant works from what exists, not from guesses.

Ask with SQL

Run read-only queries, get results in the shape you need, and understand why a query is slow.

Connections

Add databases, move between them, and find which one holds the data, with passwords kept out of the chat.

Health and performance

See how the database is doing, what's slow, what's stuck, and which indexes help or hurt.

Changes and migrations

Plan schema changes safely, and, only when you allow it, change data and run maintenance.

NexQL itself

Look after the schema index, check the setup, and load more tools when the assistant needs them.

Guides

01How a question travelsWhat happens between your question and the answer.02Access modes and guardrailsRead, write and admin, and what's blocked in every mode.03Masking personal dataWhich columns come back as <redacted>, and how to tune it.04Connections and passwordsProfiles, the keyring, and adding databases from the chat.05The schema indexHow NexQL knows your tables before it writes SQL.06Tool setsquery, dba, meta, full: how many tools your app sees.07Prompts and resourcesReady-made tasks your app can offer as slash commands.08Command lineEvery nexql-mcp command, from setup to diff.09Configurationconfig.toml fields, environment variables, HTTP mode.