DuckDB plugins

Query SQL databases and tabular files using SLQ or native SQL, manage database sources, inspect schemas, and diff tables from the command line

Build and manage PortalJS data portals: recommend an architecture, scaffold a portal, add datasets (CSV/TSV/JSON/GeoJSON), create charts (recharts) and interactive maps (Leaflet), connect a CKAN backend, harvest datasets from open-data platforms, infer data schemas, audit data quality, and deploy to PortalJS Arc hosting.

Read, write, search, and surgically edit Obsidian notes, tags, and frontmatter via the Local REST API plugin, using either STDIO or Streamable HTTP transport.

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.

Transform an Obsidian vault into an AI-powered second brain with automated journaling, health-metric tracking, knowledge graph generation, and pattern recognition. Sync data from GitHub, Slack, Notion, Gmail, Linear, and wearables, then extract insights and generate content for creators and teams.

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 hundreds of New Zealand public datasets — transport, weather, property, business, fuel, health, and more — via simple CLI commands. No API keys needed for most sources.

Enforce evidence-gated development workflows that prevent self-asserted 'done' from passing — re-derives results through independently attested gates, traces code relationships beyond static analysis, runs multi-model second opinions, and applies structured archetypes (build, migrate, ship, review, incident response) with rigor scaling to complexity and blast radius.

Analyze data, explore schemas, build insights, and run forecasts using AI agents on the Altertable platform, with support for DuckDB, Snowflake, BigQuery, and more.