$ loading_
Provides PostgreSQL skills and docs so AI coding tools write better database code.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "pg-aiguide" yet — see the docs or source repo.
Using PostgreSQL best practices, write a query for the orders and customers tables to calculate each customer's total order amount in the last 30 days, optimize for performance, and explain whether indexes are needed.
A runnable PostgreSQL query with performance optimization notes and index recommendations.
Design a PostgreSQL schema for a blog system with users, posts, and comments tables, including primary keys, foreign keys, unique constraints, and common indexes, and explain the design choices.
Complete CREATE TABLE SQL plus explanations for constraints and indexes.
Based on PostgreSQL documentation, compare JSON and JSONB, then recommend which to use for log storage and provide example SQL.
A documentation-based comparison, recommendation, and example SQL.
Let AI query, inspect, and modify a local PostgreSQL database with SQL.
Query PostgreSQL, inspect schemas, and run SQL safely with natural language.
Query and explore PostgreSQL databases with SQL, tables, and schema inspection.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Query PostgreSQL databases and schemas through natural language with read-only AI access.
Securely query and manage PostgreSQL databases for operations and automation.