Which integrations are available for this server?

Provides a query tool to run parameterized SQL statements against a PostgreSQL database, returning command, rowCount, and rows as JSON.

How do I use sql-mcp?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@sql-mcp SELECT \* FROM users" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

sql-mcp

Local MCP server exposed over HTTP that runs inside Docker and provides a single query tool against a PostgreSQL database supplied via DATABASE_URL.

Configure

cp .env.example .env
# edit .env and set DATABASE_URL

Run with Docker

docker compose up --build

The MCP endpoint is then available at http://localhost:3000/mcp.

Run locally (without Docker)

npm install
npm run build
npm start
# or, for hot reload:
npm run dev

Register with an MCP client

Point your MCP-compatible client at the streamable HTTP endpoint:

http://localhost:3000/mcp

The transport is streamable-http. Initialize the session with a standard MCP initialize request; subsequent requests must include the mcp-session-id header returned by the server.

Tool

query({ sql: string, params?: unknown[] }) — runs a parameterized SQL statement and returns { command, rowCount, rows } as JSON. Use $1, $2, ... in sql and pass values in params.