Query PostgreSQL databases read-only via psql for schema introspection and EXPLAIN plans.
npx skills add https://github.com/dversoza/claude-skills --skill postgres-dversoza
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/dversoza/claude-skills/tree/main/postgres Command: npx skills add https://github.com/dversoza/claude-skills --skill postgres-dversoza
This Skill provides secure, read-only access to PostgreSQL databases, allowing you to query data, inspect schemas, and analyze query plans without the risk of accidental data modification.
default_transaction_read_only=on at the PostgreSQL session level, preventing writes and DDL.EXPLAIN plans for performance analysis.users table of your staging database.Use the postgres skill to list all tables in the public schema of the staging database.
High-intent search queries and answers about installing and using this skill.
Read-only PostgreSQL queries are enforced by setting default_transaction_read_only=on at the session level, preventing accidental writes and DDL while allowing schema introspection and data retrieval.
PostgreSQL database schema introspection lets you list schemas, tables, columns, and indexes using the psql client, provided database connection URIs are configured in your environment.
PostgreSQL query plan analysis generates EXPLAIN plans through the psql client, enabling performance evaluation for development and auditing tasks within a secure read-only session.
Yes, the psql client must be installed locally, and database connection URIs must be configured in CLAUDE.local.md to establish secure read-only PostgreSQL database access.
No, read-only PostgreSQL sessions enforce default_transaction_read_only=on at the session level, which blocks all write operations and DDL statements to prevent accidental data modification.
Database connection URIs for PostgreSQL access are configured in the CLAUDE.local.md file, which the psql client reads to establish a secure read-only session for querying and introspection.
pgEdgeQuery and modify PostgreSQL databases via psql with compact CSV outputs.
weirdgmeDesign and implement scalable platform engineering patterns for internal developer platforms.
jeremydhoover-blipManage documentation with version control, CI/CD, and automated testing.
albertdobmeyerManage SQL database tasks across SQLite, PostgreSQL, and MySQL.