What problem does it solve?
This Skill automates PostgreSQL database management, allowing you to query data, inspect schemas, analyze performance, and validate migrations without tedious manual SQL commands. It ensures data integrity and optimal database health.
Core Features & Use Cases
- Data Query & Analysis: Execute SQL queries to retrieve and analyze data, supporting debugging and reporting.
- Schema Inspection: Explore table structures, columns, relationships, and indexes to understand database design.
- Performance Optimization: Debug slow queries by getting execution plans and suggesting index improvements.
- Use Case: When investigating a bug related to user data, use this skill to query the
users table, inspect its schema, and verify data integrity, quickly pinpointing database-related issues.
Quick Start
Use the postgres-manager skill to list all tables in the current database and then describe the schema for the 'users' table.