Postgres docs and skills. Helps AI coding tools generate better PostgreSQL code.
⭐ Why pg-aiguide?
AI coding tools often generate Postgres code that is:
- outdated
- missing constraints and indexes
- unaware of modern PG features
- inconsistent with real-world best practices
pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.
🚀 Quickstart
pg-aiguide is available as a public MCP server:
https://mcp.tigerdata.com/docs
💡 Your First Prompt
Once installed, pg-aiguide can answer Postgres questions or design schemas.
Simple schema example prompt
Create a Postgres table schema for storing usernames and unique email addresses.
Complex schema example prompt
You are a senior software engineer. You are given a task to generate a Postgres schema for an IoT device company. The devices collect environmental data on a factory floor. The data includes temperature, humidity, pressure, as the main data points as well as other measurements that vary from device to device. Each device has a unique id and a human-readable name. We want to record the time the data was collected as well. Analysis for recent data includes finding outliers and anomalies based on measurements, as well as analyzing the data of particular devices for ad-hoc analysis. Historical data analysis includes analyzing the history of data for one device or getting statistics for all devices over long periods of time.
Features
Semantic Search
-
semantic_search_postgres_docsPerforms semantic search over the official PostgreSQL manual, with results scoped to a specific Postgres version. -
semantic_search_tiger_docsSearches Tiger Data’s documentation corpus, including TimescaleDB and future ecosystem extensions.
Skills (AI-Optimized Best Practices)
-
view_skill
Exposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants.These skills provide guidance on:
- Schema design
- Indexing strategies
- Data types
- Data integrity and constraints
- Naming conventions
- Performance tuning
- Modern PostgreSQL features
Server Config
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}