Run read-only PostgreSQL queries via psql with writes blocked by default.
npx skills add https://github.com/Anras573/AIchemist --skill postgresql-query
Please help me install this Agent Skill. Skill: PostgreSQL Query Source: https://github.com/Anras573/AIchemist/tree/main/skills/postgresql Command: npx skills add https://github.com/Anras573/AIchemist --skill postgresql-query
This skill enables safe PostgreSQL querying by performing automatic read operations while blocking writes by default, preventing accidental data modification during exploration.
Run a simple SELECT query against the connected PostgreSQL database and return the results in a readable format.
High-intent search queries and answers about installing and using this skill.
You can safely query a PostgreSQL database by using a read-only mode that performs SELECT operations and blocks writes by default. This guardrail prevents accidental data modification during schema exploration and data retrieval.
Write operations like INSERT or UPDATE are blocked by default to ensure safe data access. You must provide explicit opt-in to enable writes, ensuring strict guardrails are in place during analytics and debugging sessions.
You can explore a database schema using the psql client by running automatic read operations against the connected PostgreSQL database. This allows quick data retrieval and schema exploration across different environments without write permissions.
Yes, you need a POSTGRES_URL connection string to retrieve sample rows from a production database. The tool operates via the psql client using this URL to establish a safe, read-only connection for validating hypotheses.
The limitation of read-only PostgreSQL querying is that all write operations are blocked unless explicitly enabled. This means you cannot modify data during exploration without first opting into write permissions.
dversozaQuery PostgreSQL databases read-only via psql for schema introspection and EXPLAIN plans.
take566Analyze data with pandas, SQL, and BigQuery to generate charts and reports.
dhruvinrsoniDesign relational and NoSQL database schemas with migrations and indexes.
shalevaminAnalyze PostgreSQL query execution plans and design efficient indexes.
