Executes read-only SQL queries on configured PostgreSQL databases with schema exploration support.
npx skills add https://github.com/pohlai88/AFENDA --skill postgres-pohlai88
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/pohlai88/AFENDA/tree/main/.agents/skills/postgres Command: npx skills add https://github.com/pohlai88/AFENDA --skill postgres-pohlai88
This Skill allows you to safely execute read-only SQL queries against multiple PostgreSQL databases, making data exploration and retrieval efficient and secure.
Use the postgres skill to list all tables in the 'production' database.
High-intent search queries and answers about installing and using this skill.
Use a Skill that enforces read-only sessions, validates statements to allow only SELECT, SHOW, EXPLAIN, and WITH commands, and prevents multi-statement execution to safely query a PostgreSQL database without risking data modification.
Yes, you can explore database schemas and list tables in PostgreSQL without modifying data by executing queries through a read-only session that restricts all write operations and enforces single-statement execution.
Querying PostgreSQL with Python requires installing the psycopg2-binary dependency to establish database connectivity and execute SQL queries safely through the configured read-only sessions.
When executing read-only queries in PostgreSQL, only SELECT, SHOW, EXPLAIN, and WITH statements are allowed. The query validation process rejects multi-statement attacks and enforces single-statement execution.
To query multiple PostgreSQL databases, you configure connections using a configuration file that allows you to connect to and query various databases safely while enforcing timeouts and memory caps.
Limitations of using a read-only PostgreSQL query tool include the inability to modify data, execute INSERT or UPDATE statements, run multiple statements in a single query, and exceed configured query timeouts or memory caps.
Interstellar-codeExecute SQL queries against MySQL and PostgreSQL databases from the command line.
gman-roboticsAnalyze Excel and CSV files with DuckDB SQL queries and export results.
xiaoyuge886Explore schemas, inspect tables, and execute SQL queries across multiple database engines.
w95Execute read-only SQL queries against multiple PostgreSQL databases.
