Execute read-only SQL queries against configured PostgreSQL databases.
npx skills add https://github.com/bouwerp/agentic-framework --skill postgres-bouwerp
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/bouwerp/agentic-framework/tree/main/skills/postgres Command: npx skills add https://github.com/bouwerp/agentic-framework --skill postgres-bouwerp
It enables safe, read-only access to PostgreSQL databases for schema exploration, data validation, and debugging without risking writes.
Configure a read-only connections.json and run python3 skills/postgres/scripts/query.py --db production --query 'SELECT 1'.
High-intent search queries and answers about installing and using this skill.
Configure a read-only connections.json file with your database credentials, then execute queries using the Python query script. This setup enforces a read-only session, single-statement policy, and statement timeouts to prevent unauthorized writes during schema exploration.
A safe read-only PostgreSQL session allows SELECT, SHOW, EXPLAIN, and schema introspection queries. It enforces a single-statement policy and blocks any data modification commands to ensure safe data validation and debugging without risking writes.
Yes, you need psycopg2 installed as it is the required dependency for executing the read-only SQL queries. The Python script relies on it to connect to PostgreSQL databases and enforce the single-statement, read-only session policies.
Yes, you can inspect table schemas across multiple configured PostgreSQL databases. The tool supports listing configured databases and executing targeted read-only queries with optional row limits for comprehensive schema exploration.
The single-statement policy limits executing multiple SQL commands in one query, preventing complex transactions or batch operations. This constraint, combined with statement timeouts, ensures strict read-only safety but restricts advanced multi-statement query chaining.
aubrian-haliliQuery and inspect the backoffice PostgreSQL database with read-only SQL.
gman-roboticsAnalyze Excel and CSV files with DuckDB SQL queries and export results.
xukrutdonutExecute SQL queries and manage schemas across PostgreSQL, MySQL, SQLite, MongoDB, and Redis.
myoshi2891Manage PostgreSQL schema definitions, migrations, and data seeding with Prisma ORM.
