Postgresql Psql

What it does

This skill allows AI agents to interact with PostgreSQL databases using psql, a command-line tool. It can execute SQL queries, manage database connections, and retrieve data from PostgreSQL instances. The agent can be instructed to perform tasks like retrieving specific records or updating table entries based on given instructions.

When to use it

• Data Extraction: Retrieve information from a PostgreSQL database for reporting or analysis purposes.
• Database Administration: Execute administrative commands such as creating tables, users, or granting permissions.
• Application Integration: Interact with applications that store data in PostgreSQL, allowing the agent to perform actions like updating customer records.
• Troubleshooting: Run diagnostic queries and check database status for troubleshooting issues.

Key capabilities

• Execute SQL commands via psql.
• Manage database connections.
• Retrieve data from PostgreSQL instances.

Example prompts

• "Run the query 'SELECT * FROM customers WHERE city = 'New York'' against the database named 'sales'."
• "Create a table called 'products' with columns for id, name, and price."
• "Connect to the PostgreSQL server at 192.168.1.100 on port 5432 using username 'dbuser' and password 'password'."

Tips & gotchas

• Requires a working PostgreSQL database instance and psql client installed and accessible.
• Ensure the AI agent has appropriate credentials to connect to and interact with the target database.