PostgreSQL MCP by InsightfulPipe
RemoteAbout PostgreSQL MCP by InsightfulPipe
PostgreSQL MCP by InsightfulPipe is a hosted remote server for AI assistants to inspect PostgreSQL schemas, run SQL, and review database health. Per-account action controls and database role grants determine which operations are available.
Key features
- 01Browse schemas, tables, and views
- 02Inspect columns, constraints, and indexes
- 03Run SQL and view query plans
- 04Check database health and slow queries
- 05Enable or disable actions per account
Use cases
- 01Inspect database table structures
- 02Analyze SQL query plans
- 03Review database health
MCP support
The remote MCP server exposes PostgreSQL schema browsing, table metadata, query execution, and health checks to MCP clients. Per-account action controls and database role permissions govern read and write access.
Configuration
Remote servers need no local install. Pick your client, then copy the config or install in one click.
https://postgresql.insightfulmcp.com/claude mcp add --transport http com-insightfulpipe-postgresql https://postgresql.insightfulmcp.com/{"mcpServers":{"com-insightfulpipe-postgresql":{"type":"http","url":"https://postgresql.insightfulmcp.com/"}}}Open in Cursor{"servers":{"com-insightfulpipe-postgresql":{"type":"http","url":"https://postgresql.insightfulmcp.com/"}}}Open in VS Code{"mcpServers":{"com-insightfulpipe-postgresql":{"type":"http","url":"https://postgresql.insightfulmcp.com/"}}}{"mcpServers":{"com-insightfulpipe-postgresql":{"serverUrl":"https://postgresql.insightfulmcp.com/"}}}Run commands in a terminal; paste JSON into the client’s MCP config and restart. Servers that need sign-in will prompt on first connect.
Tools
Details
From the project READMEPostgreSQL MCP Server by Insightful Pipe
Connect PostgreSQL to AI assistants: schemas, tables, SQL and database health.
Part of the Insightful Pipe MCP Server Collection — use PostgreSQL from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).
MCP Server URL
https://postgresql.insightfulmcp.com/
What is PostgreSQL MCP?
PostgreSQL MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Browse schemas and tables, inspect columns, run SQL, and read pg_stat insights against your own PostgreSQL database. Read vs. read-write is decided by the GRANT/REVOKE privileges on the role this connector logs in as.
Installation
Claude
- Copy the MCP Server URL:
https://postgresql.insightfulmcp.com/ - Open Claude Connectors Settings
- Scroll to the bottom and click Add custom connector
- Paste the URL and click Add
- Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.
ChatGPT
Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.
- Turn on Developer mode in ChatGPT settings
- Create a new app for a remote MCP server and paste the URL:
https://postgresql.insightfulmcp.com/ - Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.
See OpenAI's guide: Developer mode and MCP apps in ChatGPT
Claude Code
claude mcp add --transport http postgresql https://postgresql.insightfulmcp.com/
Cursor
Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):
{
"mcpServers": {
"postgresql": {
"url": "https://postgresql.insightfulmcp.com/"
}
}
}
When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.
Available Actions
8 actions: 7 read, 1 write.
Read Actions (7)
| Action | Description |
|---|---|
analyze_db_health | Report database health (connections, vacuum age, replication slots, cache hit rates, invalid constraints) |
explain_query | Return the EXPLAIN plan for a query |
get_table_metadata | Full metadata for a table or view: columns, constraints, indexes, estimated row count, size |
get_table_schema | Return the column list (name, data_type, is_nullable, default) for a table or view |
get_top_queries | Slowest or most resource-intensive queries from the pg_stat_statements extension |
list_schemas | List all schemas in the connected database |
list_tables | List tables, views, sequences, or extensions in a schema |
Write Actions (1)
| Action | Description |
|---|---|
run_query | Execute a SQL statement against the connected database |
Control What Your AI Can Do
You decide what AI agents can do with each connected account:
- Turn individual actions on or off for every connected account, so agents only see the actions you allow.
- Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
- Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
- Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.
Usage Examples
"List the tables in the public schema"
"Show the schema of the orders table"
"Check my database health"
Pricing
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 you can try it for 7 days. See insightfulpipe.com/pricing for current plans.
Explore More MCP Servers by Insightful Pipe
Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.
Resources
Support
- Documentation: insightfulpipe.com/docs
- All MCP Servers: insightfulpipe.com/mcp-servers
- Email: [email protected]
Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →
License
MIT License - see LICENSE for details.
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.