DuckDB plugins

Build and optimize data analytics workflows: enforce A/B testing gates, audit tracking systems, design data layers, tune SQL queries across Postgres/Snowflake/BigQuery/DuckDB, and create d3.js visualizations.

Query SQL databases and tabular files using sq's SLQ or native SQL, manage data sources, inspect schemas, and diff tables.

Build and manage data portals with PortalJS — scaffold from a brief, add datasets with charts and maps, connect CKAN backends, deploy to Cloudflare, audit data quality, and emit DCAT feeds for government open-data portals.

Manage Microsoft Fabric workspaces, lakehouses, and notebooks via the fabric CLI, with automation for capacity migration and access to Microsoft Learn training content.

Process healthcare workflows including prior authorization, ICD-10 coding, clinical note extraction, trial protocol generation, and FHIR data access with bundled MCP connectors to CMS Coverage, NPI Registry, Clinical Trials, and PubMed.

Build and validate Sidemantic semantic models, generate SQL queries, and create analytics webapps or dashboards using React/Tailwind components.

Automate dbt model development, debugging, refactoring, documentation, and data quality testing, plus Snowflake query optimization and cost analysis, via Claude Code skills that delegate to a specialized data engineering CLI agent.

Search, trace provenance, find downstream usage, and discover similar resources in the KG-Registry knowledge graph repository via DuckDB queries on live Parquet files, with no local clone needed.

Transform an Obsidian vault into an AI-powered second brain with daily journaling, knowledge graph generation, health data integration, pattern recognition, and meeting workflow automation. Includes instinct engine for capturing reusable patterns, security auditing, and content repurposing from talks.

Analyze Claude Code session transcripts to detect anti-patterns, tool misuse, frustration signals, and workflow inefficiencies, then generate actionable improvements like hook configs, prompt patches, and automation scripts.

Analytics engineering for data warehouses: explore schemas, detect PII and data quality issues, answer ad-hoc queries via guarded SQL. Author and refactor dbt projects with SQL models, tests, docs, and MetricFlow semantic layers. Detect and reconcile schema drift across dbt projects.

Scaffold, develop, test, and deploy MCP servers built on @cyanheads/mcp-ts-core with code generation, SQLite/DuckDB data pipelines, OpenTelemetry monitoring, Cloudflare Workers deployment, security auditing, and automated release workflows.

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.

Query and analyze protein structures from PDB and AlphaFold databases via an MCP server, enabling sequence retrieval, structure analysis, and bioinformatics queries without an API key.