What the pg-aiguide MCP server does
The pg-aiguide MCP server exposes searchable PostgreSQL documentation to AI coding assistants through the Model Context Protocol. Its documentation sources include the official PostgreSQL manual, TimescaleDB material, and PostGIS material. PostgreSQL content is version-aware, which helps an agent distinguish guidance for different database releases.
The repository also contains AI-oriented skills that provide curated PostgreSQL practices. These skills are distributed separately through the npx skills command and can be used with supported coding agents. They are not the same as the remote MCP endpoint, but they can complement it when an agent is generating or reviewing database code.
Reach for this server when an assistant needs authoritative reference material while writing SQL, planning a schema, or working with PostgreSQL extensions. It is also relevant when generated code needs current PostgreSQL features, constraints, indexes, or established design patterns.
How it works
The hosted endpoint uses a remote HTTP MCP connection:
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
After the connection is added to an MCP-capable client, the agent can use the server to search the available manuals. The pg-aiguide MCP server does not require a connection to the user’s PostgreSQL database for the documented search workflow.
The repository additionally offers a schema exploration skill for investigating an existing PostgreSQL database. That workflow is installed as an agent skill rather than described as an MCP database connection.
Setup and configuration
Use the public endpoint at https://mcp.tigerdata.com/docs. A client can be configured manually with the JSON shown above, or through client-specific commands and installation links in the repository. The documented setup includes Cursor, VS Code, VS Code Insiders, Visual Studio, Goose, Claude Code, Codex, Gemini CLI, OpenCode, Windsurf, and LM Studio.
Claude Code can install the repository plugin with:
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
That plugin combines the repository’s skills with access to the public documentation endpoint. Codex, Gemini CLI, and VS Code also have documented commands for adding the remote server. OpenCode uses a remote MCP entry with the same URL.
For the separate skills, install the standard PostgreSQL guidance with:
npx skills add timescale/pg-aiguide --skill postgres
The schema exploration skill is installed with --skill schema-exploration; omitting the skill name opens the interactive selection flow.
Tools and capabilities
The pg-aiguide MCP server supports:
- Semantic search over the official PostgreSQL manual.
- Version-aware PostgreSQL documentation lookup.
- Search across TimescaleDB documentation.
- Search across PostGIS documentation.
- Retrieval of reference material for PostgreSQL questions and schema design.
Repository skills extend the setup with curated PostgreSQL best practices and a schema exploration workflow. The PostgreSQL skill is intended to guide coding agents toward practices such as appropriate constraints, indexes, naming, documentation, and modern PostgreSQL features, while the schema exploration skill is intended for examining an existing database.
Limitations and notes
The MCP service is public and remote, so client access depends on the configured endpoint being reachable. The repository describes the documentation corpus as starting with TimescaleDB and expanding over time; no complete list of future sources is specified.
The repository’s examples demonstrate schema generation and PostgreSQL guidance, but they do not establish that generated SQL is automatically validated or applied to a database. Review agent-produced schemas and queries before using them in development or production.
The MCP endpoint and the agent skills are related but distinct delivery methods. Connecting the endpoint provides semantic documentation search; installing the skills adds curated instructions and, optionally, schema exploration behavior.