postgres

What it does

This skill allows you to execute read-only SQL queries against one or more PostgreSQL databases. It's designed for retrieving data and examining schema information without modifying the underlying database state. You can use this skill to explore existing data, analyze tables, and run SELECT statements for various reporting or analytical purposes.

When to use it

• Data Exploration: Quickly examine the contents of a table to understand its structure and data distribution.
• Schema Discovery: List all tables in a database or view column definitions without needing direct database access tools.
• Report Generation: Run complex SELECT queries to extract specific data points for creating reports.
• Data Validation: Verify the integrity of data by running queries that check for expected values and patterns.

Key capabilities

• Execute read-only SQL queries
• Supports multiple PostgreSQL databases
• Focuses on SELECT statements and schema exploration
• Provides access to database schemas and tables

Example prompts

• "Show me all the columns in the 'customers' table."
• "Run this query: SELECT COUNT(*) FROM orders WHERE order_date > '2023-01-01'"
• "List all tables in the 'sales_db' database."

Tips & gotchas

• Ensure you have the necessary connection details (host, port, database name, username, password) for the PostgreSQL databases you intend to query. The skill requires these credentials to function correctly.