DuckDB plugins

Query SQL databases and tabular files directly from the terminal using sq's SLQ or native SQL, with capabilities to manage data sources, inspect schemas, diff tables, and handle various output formats

Build and deploy data portals with PortalJS — scaffold a portal from a brief, add datasets and resources, create charts and interactive maps, connect a CKAN backend, harvest datasets from open-data platforms, define schemas, deploy to Cloudflare static hosting, and audit data quality.

Search PubMed and Europe PMC biomedical literature, fetch full-text articles via PMC/EPMC/Unpaywall, retrieve citations and MeSH terms, and integrate the results into AI agent workflows through the MCP protocol.

Define and manage semantic models that map database tables to business dimensions and metrics, then generate analytics webapps with copyable React/Tailwind components from those models. Supports importing from Cube, dbt, and LookML, and validates queries against the semantic layer.

Turn an Obsidian vault into an AI-powered second brain with daily journaling, health-metric tracking, knowledge graph generation, pattern recognition, and meeting workflows — all orchestrated through Claude Code skills and commands.

Manage and automate YAML workflow playbooks for LLM agents via MCP, including storing, querying, and creating playbooks with built-in scaffolding, testing, deployment, and security auditing for MCP servers built on @cyanheads/mcp-ts-core.

Query live New Zealand public data across transport, energy, weather, property, retail, government, and market sectors via read-only CLI connectors — no API keys or authentication required.

Augments coding agents with evidence-gated workflows: re-derives 'done' via independently attested gates, maps code relationships for blast-radius analysis, runs deterministic multi-file refactors, cross-session memory, multi-model councils, and compliance audits. Installs a self-contained evidence gate into any repo that works without the plugin installed.

Analyze product and web analytics data using the Altertable AI platform — query a DuckDB lakehouse with SQL, build conversion funnels and user segments, detect trends and anomalies in time series, manage discoveries and insights, and automate monitoring alerts, all through agent skills that connect to Altertable's remote API.