Dokhacgiakhoa PostgreSQL MCP Skill
🎯 Goal
Enable the AI Agent to inspect schemas and execute queries on PostgreSQL databases using the official Model Context Protocol standard.
🛠️ Tools
query
Execute a unified SQL query.
- sql: The SQL query to execute (string)
get_schema
Inspect the database schema.
- table_name: Optional table name to filter schema inspection (string)
analyze_query_performance
Run EXPLAIN ANALYZE on a query to check performance.
- sql: The SQL query to analyze (string)
🚀 Usage Rules
- Read-Only Preference: Prefer
SELECTqueries unless explicitly instructed to modify data. - Transaction Safety: For multiple write operations, ensure valid transaction logic (though often handled by the tool).
- Schema Awareness: Always run
get_schemabefore constructing complex queries to ensure column names are correct. - Security: Do not execute destructive queries (
DROP,TRUNCATE) without explicit user plan approval.