English Français العربية

PostgreSQL MCP by InsightfulPipe

السجل الرسمي البيانات وقواعدها

Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

الشيفرة المصدرية الموقع التوثيق

التثبيت

أضف هذا إلى إعدادات MCP في عميلك (Claude Desktop: claude_desktop_config.json، وCursor: ‏.cursor/mcp.json، ويستخدم VS Code وغيره الصيغة نفسها «mcpServers»).

Remote (streamable-http)
Claude Code 
claude mcp add --transport http postgresql-mcp-by-insightfulpipe 'https://postgresql.insightfulmcp.com/'
إعداد JSON (Claude Desktop وCursor وVS Code) 
{
    "mcpServers": {
        "postgresql-mcp-by-insightfulpipe": {
            "type": "http",
            "url": "https://postgresql.insightfulmcp.com/"
        }
    }
}

التوثيق

مأخوذ من ملف README للمشروع على GitHub ويُحدَّث أسبوعيًا. تفتح الروابط على GitHub.

المحتويات
  1. PostgreSQL MCP Server by Insightful Pipe
  2. MCP Server URL
  3. What is PostgreSQL MCP?
  4. Installation
  5. Available Actions
  6. Control What Your AI Can Do
  7. Usage Examples
  8. Pricing
  9. Explore More MCP Servers by Insightful Pipe
  10. Resources
  11. Support
  12. License

PostgreSQL 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
  1. Copy the MCP Server URL: https://postgresql.insightfulmcp.com/
  2. Open Claude Connectors Settings
  3. Scroll to the bottom and click Add custom connector
  4. Paste the URL and click Add
  5. 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.

  1. Turn on Developer mode in ChatGPT settings
  2. Create a new app for a remote MCP server and paste the URL: https://postgresql.insightfulmcp.com/
  3. 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)
ActionDescription
analyze_db_healthReport database health (connections, vacuum age, replication slots, cache hit rates, invalid constraints)
explain_queryReturn the EXPLAIN plan for a query
get_table_metadataFull metadata for a table or view: columns, constraints, indexes, estimated row count, size
get_table_schemaReturn the column list (name, data_type, is_nullable, default) for a table or view
get_top_queriesSlowest or most resource-intensive queries from the pg_stat_statements extension
list_schemasList all schemas in the connected database
list_tablesList tables, views, sequences, or extensions in a schema
Write Actions (1)
ActionDescription
run_queryExecute 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.

View All MCP Servers →

Resources

Support

Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →

License

MIT License - see LICENSE for details.

الأسئلة الشائعة

ما هو PostgreSQL MCP by InsightfulPipe؟

Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.

كيف أثبّت PostgreSQL MCP by InsightfulPipe؟

يعمل كخادم بعيد. في Claude Code: claude mcp add --transport http postgresql-mcp-by-insightfulpipe 'https://postgresql.insightfulmcp.com/'. وفي العملاء الآخرين، الصق إعداد JSON من هذه الصفحة في إعدادات MCP الخاصة بهم.

هل يحتاج PostgreSQL MCP by InsightfulPipe إلى مفتاح API؟

لا يذكر إدراجه في السجل أي مفتاح أو سر إلزامي. قد تتطلب بعض الميزات حسابًا لدى الخدمة التي يتصل بها.

هل PostgreSQL MCP by InsightfulPipe مفتوح المصدر؟

نعم. شيفرته متاحة على GitHub بترخيص MIT.

من يصون PostgreSQL MCP by InsightfulPipe؟

ينشره Insightful-Pipe. يدرجه AI.tn لكنه لا يصونه ولا يوصي به.

من سجل MCP الرسمي. الإدراج ليس توصية: راجع شيفرة الخادم وصلاحياته قبل منحه الوصول إلى بياناتك.