MCP App StoreMCP App StoreThis skill provides instructions and workflows for querying a local DuckDB warehouse (userdata/warehouse.duckdb). It guides agents to list tables, inspect schemas, run SQL queries, ingest CSV/Parquet/JSON files, and export results. It also prescribes an analysis workflow: run queries with -json, summarize metrics, create chart specs, and present results in markdown.
Use when the user asks to explore or analyze project data, load files into the warehouse, produce aggregations (monthly revenue, product performance), or generate charts/tables from query output. Appropriate for ad-hoc data questions like “show top products by revenue” or “load this CSV and preview rows.”
Agents that can run shell commands and SQL (CLI-capable agents) such as Copilot/Code-style agents and automation agents that can execute DuckDB binaries.
A well-structured DuckDB skill that provides clear CLI commands for querying, ingesting, and exploring data in a local DuckDB warehouse. No scripts included — purely instruction-based via SKILL.md. Clean security posture with no remote code execution, credentials, or destructive commands. Good examples of common analysis queries and output formatting options.
No scripts to run; static analysis only. Skill is instruction-only, which is appropriate for a CLI wrapper skill. Cross-references to dbt and sql-reviewer skills show good ecosystem awareness.
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.
PostgreSQL
Query and manage PostgreSQL databases via psql: run queries, inspect schemas and tables, check active connections, and perform basic administration and exports.
BigQuery
Query and manage Google BigQuery datasets with the bq CLI: run SQL, inspect schemas, list tables, load CSV/JSON, and manage partitioning.
WRDS Query & ETL Enforcement
Standards and enforcement guidance for querying WRDS data and running SAS/ETL on the WRDS grid—includes query validation, SGE submission patterns, and performan
Readwise Reader Document Management
Manage Readwise Reader documents: list, save, search, move, tag, highlight, export and bulk-edit via official and custom CLIs.
ezBookkeeping API Tools
Command-line API tools for ezBookkeeping: record and query transactions, retrieve accounts/categories/tags, and fetch exchange rates for self-hosted personal fi
Tmux Bridge
Give an agent controlled access to a local tmux terminal bridge so it can run shell commands, capture output, and manage sessions on the user's machine.
Nit (Nitter CLI)
Terminal client to browse tweets, view profiles, and search posts via Nitter instances without opening a browser.
hn — Hacker News CLI
Terminal-based Hacker News client with a CLI and optional interactive TUI for browsing top/new/best/ask/show/jobs stories, viewing threads with nested comments,
WhoDB
Database assistant for exploring and querying Postgres, MySQL, SQLite, MongoDB, Redis, Elasticsearch and ClickHouse — via MCP tools or CLI fallbacks.
Lokalise Migration — Deep Dive
Step-by-step migration guide and tooling for moving translations from Crowdin/Phrase/POEditor into Lokalise, including transforms, uploads and validation.
