PostgreSQL

by vinsidious · data-analytics · mcp-server, lobehub, validated, developer

A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

Source: https://github.com/vinsidious/mcp-pg-schema

Install

git clone https://github.com/vinsidious/mcp-pg-schema

Tags: mcp-server, lobehub, validated, developer

⭐ 38 GitHub stars · Source: lobehub

About data-analytics MCP servers and Claude skills

data-analytics MCP servers extend what AI agents can do inside Claude Code, Cursor, Copilot, Codex, and Windsurf. The Skiln directory indexes 16,000+ such integrations across 22 categories.

PostgreSQL is one of hundreds of data-analytics entries indexed on Skiln. Browse the full data-analytics category or the complete directory of Claude skills, MCP servers, agents, commands, and hooks.

Related data-analytics MCPs and skills

  • DX MCP Server by get-dx

    使用自然语言在 DX Data Cloud 上编写和执行组织数据的查询。需要通过环境变量 DB_URL 配置的 Postgres 数据库连接。

  • MySQL MCP Server by alittleyellowkevin

    A Model Context Protocol (MCP) server that provides access to a MySQL database, allowing agents to execute SQL queries. Requires a running MySQL server configured via environment variables MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.

  • ssas-mcp-server-by-cdata by cdatasoftware

    CData 提供的只读 Model Context Protocol (MCP) 服务器，用于 SQL Server Analysis Services。需要外部的 CData JDBC 驱动程序（SQL Server Analysis Services 版），必须单独下载并获得授权。该服务器使用 .prp 配置文件连接到数据源。

  • mcp-embedding-search by spences10

    A Model Context Protocol (MCP) server that queries a Turso database containing embeddings and transcript segments. Requires environment variables TURSO_URL and TURSO_AUTH_TOKEN to configure the Turso database connection.

  • Magic Garden Neo4j MCP Server by yourusername

    用于 Neo4j 图数据库操作的 Model Context Protocol (MCP) 服务器，专为 Magic Garden AI 儿童教育平台设计。需要通过环境变量（例如 NEO4J_URI、NEO4J_USER、NEO4J_PASSWORD、NEO4J_DATABASE）配置外部 Neo4j 数据库连接。

  • Conectica by darknodebros

    An MCP server that enables multiple AI models (Claude, ChatGPT, Gemini) to share and persist context via a local-first vault of markdown files and SQLite index, allowing seamless cross-AI memory.

  • MCP Database Bridge by buvaneswaraneb

    A secure, read-only MCP server that empowers Claude Desktop and AI agents to safely query and inspect local SQLite databases.

  • receipts-api-mcp by chf3198

    Enables querying and analyzing receipt data with SQL-style grouped statistics, filtering, and receipt lookup through natural language via MCP-compatible clients.

Frequently asked questions

How do I install PostgreSQL?

Add the install command above to your Claude Code, Cursor, or Windsurf MCP configuration. Most servers register via npx, a local command, or a Docker image. Refer to the source repository for environment variables and credential requirements.

Which clients support PostgreSQL?

Any MCP-compatible client works: Claude Desktop, Claude Code CLI, Cursor, Windsurf, Zed, and VS Code with the official MCP extension. OpenAI Codex and GitHub Copilot increasingly support MCP via adapter bridges.

Is PostgreSQL free?

The server itself is typically open source. Any upstream service (API keys, paid tiers, hosted infrastructure) may have its own pricing. Check the source repository for details.