PostgreSQL MCP Server

No. InsightfulPipe is an independent, hosted server and is not affiliated with the PostgreSQL Global Development Group. The Model Context Protocol project's reference PostgreSQL server, which offered a single read-only query tool, was archived in May 2025.

Any AI client that supports remote MCP servers. The setup guide on this page covers Claude, ChatGPT, Claude Code, Cursor, Gemini CLI and Codex. You can also work with the same connected accounts from the terminal with the InsightfulPipe CLI.

Yes. In Claude, add https://postgresql.insightfulmcp.com/ as a custom connector and authorize your InsightfulPipe account. You can also add InsightfulPipe from the Claude Directory, which connects all of your linked accounts at once.

Yes. Add the server URL as a custom connector in ChatGPT Developer mode, or add InsightfulPipe from the ChatGPT app directory to connect all of your linked accounts. Developer mode availability depends on your ChatGPT plan.

It can list schemas and tables, views, sequences and extensions, read columns and table metadata, run SQL, show EXPLAIN plans, run a health report and list the slowest queries from pg_stat_statements. What it can read or change is limited by the privileges of the database user you connect with.

Any statement the database user is allowed to run. InsightfulPipe classifies each request: a single SELECT runs as a read, while INSERT, UPDATE, DELETE, DDL, SELECT INTO, writing CTEs and multiple statements are treated as writes. Writes run only through the write tool and only for owners, admins and operators.

Connect with a PostgreSQL user that has only SELECT privileges, so the database rejects any write. InsightfulPipe has no separate Read-only mode for database connections, but owners, admins and operators can turn off the run query and explain query actions. EXPLAIN ANALYZE executes the statement it explains.

The database must be reachable on a public hostname or IP address, because private, loopback and link-local addresses are rejected. TLS is required: the disable, allow and prefer modes are refused, and the server certificate is verified against the hostname, with an optional CA certificate you provide. If the database is firewalled, allowlist InsightfulPipe's outbound IP addresses shown in your workspace settings.

Yes. Each connection is one database on one host, with its own name, and you can add as many as your plan allows. Each connected database counts as one connection on your plan.

You connect with a database user and password, or with a TLS client certificate and key. InsightfulPipe tests the connection before saving it and stores the password and certificates encrypted. Your AI client signs in to the MCP server with your InsightfulPipe account and never sees the database credentials.

Queries time out after at most 60 seconds, results are capped at 10,000 rows and query text at 256 KB. Databases on private networks without a public address are not supported. The top queries action needs the pg_stat_statements extension. If a write response is lost, the server reports that the outcome is unknown instead of retrying.

The PostgreSQL MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month and include a trial. See insightfulpipe.com/pricing for current plans.