$ loading_
Access PostgreSQL docs, ecosystem guidance, and best practices for development and operations.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "io.github.timescale/pg-aiguide" MCP server from askskill: Run: claude mcp add 'io-github-timescale-pg-aiguide' -- npx -y @tigerdata/pg-aiguide
Summarize PostgreSQL partitioning best practices, including use cases, common pitfalls, indexing advice, and whether the Timescale ecosystem offers additional recommendations.
A structured summary covering partition design principles, performance considerations, and relevant ecosystem tool recommendations.
Compare common PostgreSQL backup and recovery approaches, explaining their pros, cons, suitable environments, and production best practices.
A comparison list with approach differences, selection guidance, and key operational best practices.
I have a slow PostgreSQL query. Using official documentation and best practices, provide a systematic troubleshooting approach covering EXPLAIN, indexes, statistics, and configuration checks.
A step-by-step troubleshooting guide to identify causes of slow queries and suggest optimization paths.
Get PostgreSQL best practices for optimization, schema design, indexing, and security.
Query and explore PostgreSQL databases with SQL, tables, and schema inspection.
Connect to PostgreSQL across projects to inspect schemas, run queries, and analyze performance.
Analyze governed PostgreSQL DBA operations, from slow queries to lock blocking.
Query PostgreSQL securely in read-only mode using natural language.
Explore PostgreSQL schemas and run safe read-only queries for analysis.