Postgres

What it does

This skill allows AI agents to interact with and manage PostgreSQL databases. It can execute SQL queries, retrieve data, and perform database administration tasks based on natural language instructions. The agent can also create tables and insert data into existing tables.

When to use it

• You need to query a PostgreSQL database for specific information, such as sales figures or customer details.
• You want to automate repetitive database management tasks like creating new tables or updating records.
• You're building an application that requires dynamic interaction with a PostgreSQL database.
• You need to insert data into a PostgreSQL table based on instructions provided in natural language.

Key capabilities

• Execute SQL queries
• Retrieve data from tables
• Create new tables
• Insert data into existing tables

Example prompts

• "Show me the total sales for each product category."
• "Create a table called 'customers' with columns for name, email, and phone number."
• "Insert a new customer named John Doe with email [email protected] and phone 123-456-7890 into the customers table."

Tips & gotchas

The agent requires access to a PostgreSQL database and appropriate credentials to function correctly. Ensure that the necessary permissions are granted before using this skill.