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).
This skill has not been reviewed by our automated audit pipeline yet.
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.