PostgreSQL Database Manager
Manages PostgreSQL database connections and executes secure SQL queries with automated schema introspection and result formatting.
The source repository doesn't declare a license. Check its terms before reusing the code.
Key features
- Advanced schema introspection to discover tables, columns, and metadata
- Multi-format result output including Markdown tables, JSON, and CSV with pagination
- Secure parameterized query execution to prevent SQL injection
- Automated connection management supporting URL strings and individual environment variables
- Built-in connection health diagnostics and pool performance monitoring
Use cases
- Monitoring database connection health and troubleshooting configuration issues in development
- Executing and testing SQL queries with formatted data output for rapid debugging
- Exploring database structures and listing table schemas via natural language commands
FAQ
When should I use this skill during development?
Use it whenever you need to inspect database structures, verify data integrity, or debug queries without leaving the Claude Code environment. It is ideal for quickly discovering table metadata or running diagnostic queries.
Does it support complex environment configurations?
Absolutely. It features flexible pattern matching that automatically detects connection details from POSTGRES_URL strings or individual environment variables like DB_HOST and DB_USER, supporting various naming conventions out of the box.
How does this skill improve my AI coding workflow?
It provides Claude with direct visibility into your database schema. This context allows the AI to write more accurate SQL, understand data relationships, and verify that the code it generates matches your actual database structure.
What does the PostgreSQL Database Manager skill do?
This skill enables Claude Code to securely connect to your PostgreSQL databases, execute parameterized SQL queries, perform deep schema introspection, and format results into readable Markdown tables, JSON, or CSV.
Is query execution secure against SQL injection?
Yes. The skill uses prepared statements and parameterized queries as a standard practice to prevent SQL injection. Additionally, it features sensitive data redaction and connection restrictions to ensure secure local development.
Related skills
PostGIS Geospatial Development
Implements best practices for querying and managing geospatial data in PostgreSQL with PostGIS.
Database Management12 ptsSupabase Database Integration
Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible syntax while respecting Row Level Security policies.
Database Management12 ptsDatabase Connection Pooling
Optimizes database performance and reliability by configuring robust connection pools for SQLAlchemy across traditional and serverless architectures.
Database Management12 pts