Postgres Query Expert

The postgres-query-expert skill enables AI agents to execute complex PostgreSQL queries directly, transforming natural language requests into valid SQL statements for data retrieval and manipulation. It acts as a specialized interface allowing agents to interact with database schemas without requiring manual code generation or syntax verification from the user.

When to use it

• Retrieving specific records based on natural language descriptions of business logic.
• Generating aggregate reports that require multiple joins and conditional filtering.
• Validating data integrity by running diagnostic queries against production tables.
• Automating routine administrative tasks like updating status fields across large datasets.

Key capabilities

• Translates natural language prompts into executable PostgreSQL SQL code.
• Handles complex query structures including joins, subqueries, and aggregations.
• Operates within the context of a connected PostgreSQL database instance.

Example prompts

• "Find all customers who have placed orders in the last 30 days but haven't made a purchase this month."
• "Generate a report showing total revenue per category, grouped by region and sorted by highest sales volume."
• "Update the status of all pending support tickets to 'resolved' where the resolution time is less than 24 hours."

Tips & gotchas

Ensure your AI agent has explicit read/write permissions on the target PostgreSQL database before executing write operations. Always review generated SQL queries in a sandbox environment before running them against production data to prevent accidental data loss or performance bottlenecks.