Manage and query PostgreSQL databases from the command line via psql.
npx skills add https://github.com/clawdata/clawdata --skill postgres-clawdata
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/clawdata/clawdata/tree/main/skills/postgres Command: npx skills add https://github.com/clawdata/clawdata --skill postgres-clawdata
PostgreSQL administration and exploration tasks often require switching between tools and writing repetitive queries. This skill provides a concise guide to connecting to PostgreSQL, discovering databases, schemas, tables, and running common commands from the psql CLI, streamlining data work.
Install psql and set connection variables as needed, then connect and run a sample query to verify access.
High-intent search queries and answers about installing and using this skill.
Connect to a PostgreSQL database by providing a connection string or setting PG environment variables like PGHOST, PGPORT, and PGUSER. This allows direct psql CLI access to local or remote servers for querying and administration.
List PostgreSQL databases, schemas, and tables using built-in psql commands. This streamlines database exploration and schema inspection directly from the CLI without writing repetitive SQL queries.
Yes, you can execute ad-hoc SQL queries on a remote PostgreSQL server. Configure the connection using environment variables or a connection string, then run your queries via the psql command line interface.
Yes, installing the psql client is required to manage PostgreSQL databases. Once installed, set your connection variables and connect to local or remote servers to perform routine maintenance and data exploration.
The best way to perform routine PostgreSQL administration is using the psql CLI for direct server access. It supports schema inspection, table descriptions, and ad-hoc querying, streamlining maintenance without switching tools.
PostgreSQL database exploration often requires switching tools when lacking a consolidated CLI guide. Using psql commands directly addresses this by enabling schema discovery, table descriptions, and query execution in one interface.
huydepzai121Execute PostgreSQL psql commands for connections, queries, and administration.
jieni777Connect to PostgreSQL or MySQL databases to execute SQL queries and inspect schema.
Datus-aiGenerate JSON, CSV, or markdown reports from SQL query results.
pramudityadExecute SQL queries against PostgreSQL databases and return JSON results.
