Read Only Postgres

What it does

This skill allows an AI agent to query and retrieve data from a PostgreSQL database, but without write access. It can execute SELECT statements to extract information based on provided queries, enabling read-only analysis of stored data. The agent cannot modify any data within the database.

When to use it

• Data Reporting: Generate reports or summaries based on existing data in a PostgreSQL database (e.g., sales figures, inventory levels).
• Business Intelligence: Retrieve specific datasets for analysis and visualization by connecting to a reporting database.
• Information Retrieval: Answer questions that require accessing information stored within a PostgreSQL database without needing write permissions.
• Data Validation: Verify data integrity by querying the database and comparing results against expected values.

Key capabilities

• SELECT statement execution
• Read-only access to PostgreSQL databases
• Data retrieval based on user-provided queries

Example prompts

• "Retrieve all customer names from the 'customers' table."
• "What were the total sales for Q3 2023?"
• "Show me a list of products with a quantity in stock less than 10."

Tips & gotchas

• Requires valid database connection credentials (host, port, username, password, database name).
• The agent will return an error if any attempt is made to execute commands that modify data.