This skill equips an agent to interact with PostgreSQL databases using the psql CLI. It provides concrete commands for connecting, listing databases, schemas and tables, describing tables, running queries, checking active and long-running queries, inspecting index usage, and importing/exporting CSVs. It also includes best-practice advice such as using EXPLAIN ANALYZE, connection pooling, statement_timeout, and pg_dump for backups.
Use this skill when a user asks for SQL queries, schema inspection, table descriptions, row counts, performance troubleshooting for Postgres, or commands to export/import data. Good for on-the-fly diagnostics, data exploration, and basic DBA tasks.
Useful for agents that can run shell commands and are allowed to access DB credentials (psql).
A well-structured PostgreSQL administration skill providing psql CLI commands for common DB tasks: listing databases/schemas/tables, running queries, checking connections, exporting/importing CSV, and monitoring. No bundled scripts — pure instruction-based. Clean frontmatter with properly declared secrets and metadata. Straightforward and practical for anyone working with Postgres.
No security concerns. Skill is a clean CLI-wrapper with no scripts, no network calls beyond DB connection, no destructive commands without explicit user intent. Connection string pattern uses standard PostgreSQL URI format with placeholder credentials.
Dagster
Build and manage Dagster data pipelines -- create assets, jobs, schedules, sensors, and resources.
Dlt
Build data ingestion pipelines with dlt (data load tool) -- extract from APIs, databases, and files, then load to any destination.
dbt CLI Assistant
Run and manage dbt projects via the dbt CLI — initialise projects, run/build models, run tests, generate docs, and debug pipelines.
Metabase (dashboard & questions manager)
Manage Metabase instances: create and run questions, manage dashboards and collections, and interact with the Metabase REST API for analytics workflows.
BigQuery
Query and manage Google BigQuery datasets with the bq CLI: run SQL, inspect schemas, list tables, load CSV/JSON, and manage partitioning.
DuckDB — Local Warehouse Explorer
Run SQL and explore a project DuckDB warehouse: list tables, inspect schemas, run queries, and ingest CSV/Parquet/JSON files for ad-hoc analysis.