pg-aiguide MCP
An MCP server and skills from TigerData that help agents write PostgreSQL schemas and queries from current docs and practices
- 1,878 ★ on the repository
- Last commit
- Apache-2.0
Extended access
Why this level
- Agent queries go to TigerData's remote server
- Skills generate DDL and migrations that need review before applying
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add mcp/pg-aiguideDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- Agent queries go to TigerData's remote server
- Skills generate DDL and migrations that need review before applying
This is third-party code. Review the repository files before installing.
What it does
The project targets common agent weaknesses with PostgreSQL: outdated syntax, missing constraints and indexes, and unawareness of newer features. The public MCP server exposes search_docs with semantic and BM25 search over the version-aware PostgreSQL manual plus TimescaleDB and PostGIS docs. Skills cover table design, PostGIS spatial tables, TimescaleDB hypertables and migrating to them, pgvector semantic search, hybrid text search and database migrations. It installs as skills, as a remote MCP server or as a Claude Code plugin.
Who it is for. For backend developers and data engineers designing PostgreSQL databases with an agent.
Good fit when
- The agent designs a PostgreSQL schema and needs proper constraints and indexes
- You are setting up time series on TimescaleDB or geodata on PostGIS
- You want the agent's answer checked against the manual for your PostgreSQL version
Not a fit when
- The database is MySQL, SQLite or another DBMS
- You need the agent to access your live database: the server only searches documentation
Example request
Design a PostgreSQL schema for IoT sensor telemetry with fast recent-data analysis and long historyMCP
- Transport
- http
- Authentication
- not required
Limitations
The remote MCP server is hosted by TigerData, so queries go to their infrastructure. Some skills lean toward Timescale ecosystem choices. pgvector documentation support is listed as coming later.
How to disable. Remove the pg-aiguide server from the agent's MCP config, the plugin via claude plugin uninstall, or the skill folders from the agent directory.
FAQ
Is an API key needed?
No, the public server connects by URL without authentication.
How do skills differ from the MCP server?
Skills give ready design rules, while the MCP server searches full documentation. The authors suggest using both.
Discussion
No questions or reviews yet.
Related
MCP serversAn MCP server for PostgreSQL with several databases at once, table descriptions from the catalog, PostGIS and pgvector hints and query plans
pgEdge Postgres MCP
pgEdge Postgres MCP Server
Postgres MCP in Go with read-mode queries, EXPLAIN plans, semantic search, several databases and a ready chat client and web interface
A Go MCP server that lets an agent ask a PostgreSQL database questions in plain language and returns the query result
A token-lean MCP server for PostgreSQL, MySQL, MariaDB, SQL Server and SQLite with a read-only mode
A lightweight database workspace with an MCP server: the agent reads the schema, runs queries and explores data in PostgreSQL, MySQL and more
Postgres MCP (Microsoft)
Postgres MCP Server (Microsoft)
Postgres MCP from Microsoft: connection profiles with passwords in the OS keyring, Entra ID sign-in for Azure, queries, schema, CSV and server metrics
README in short
The README compares e-commerce schemas generated with and without the server: more constraints and indexes and modern PostgreSQL constructs. It covers installing skills via npx skills, connecting the remote MCP in Claude Code, Codex, Cursor, Gemini CLI, OpenCode, VS Code and Windsurf, and installing the Claude Code plugin. It describes the search_docs and view_skill tools and supported doc corpora. Apache 2.0 licensed.