SQLite plugins

Run a complete academic research pipeline from deep literature review through writing, peer review simulation, revision, and finalization, with citation verification, cross-source synthesis, and AI-usage disclosure generation.

Run comprehensive SEO audits and optimizations: crawl up to 500 pages, analyze backlinks and Core Web Vitals, validate schema and hreflang, generate content clusters and sitemaps, and track regressions—all from Claude Code.

Write SQL across data warehouses, profile datasets, and generate interactive dashboards and publication-quality charts. Connect to BigQuery, Amplitude, Hex, and Atlassian for integrated data analysis and reporting.

Build and manage Cloudflare applications: create serverless Workers, stateful Durable Objects, AI agents with React hooks, enforce Zero Trust policies, and audit web performance using CLI tools and MCP integrations.

Run a complete AI-assisted coding workflow with self-correcting memory, persistent FTS5-indexed research wikis, auto-research loops, multi-LLM council deliberation, and 8 specialized agents that coordinate parallel sessions, enforce quality gates, audit context costs, and capture learnings across every session.

Automate long-form webnovel creation: initialize projects interactively with genre/characters/worldbuilding/outlines, generate beat sheets/chapters (2000+ words), extract entities/relationships to SQLite indexes, visualize status/entity graphs in read-only dashboard, recover interrupted workflows, and validate chapters via agents for inconsistencies, pacing, OOC, reader pull, and quality reports.

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

Analyze slow SQL queries and receive optimized rewrites, index recommendations, execution plan insights, anti-pattern fixes, and performance estimates for PostgreSQL, MySQL, and SQLite databases.

Build production-grade LLM gateways with OpenRouter: route requests across 400+ models by task or criteria, chain fallbacks for reliability, cache responses to cut costs/latency, monitor usage/costs/latency, redact PII for compliance, and benchmark performance using Python OpenAI SDK wrappers.

Introspect PostgreSQL, MySQL, SQLite, and MongoDB schemas to generate Markdown documentation and interactive HTML reports with ERD diagrams, relationships, indexes, constraints, views, procedures, and data dictionaries for onboarding, audits, and compliance.

Calculate cryptocurrency capital gains taxes from exchange CSV transaction data using FIFO, LIFO, or HIFO methods. Identify taxable events across trading, DeFi, NFTs, and mining. Generate compliant tax reports and forms like Form 8949 for US, UK, and EU jurisdictions.

Generate automated backup scripts, cron schedules, restore procedures, monitoring setups, and recovery plans for PostgreSQL, MySQL, MongoDB, and SQLite databases, including compression, encryption, and retention policies with AWS support.

Automate database testing workflows by generating test suites with data factories, transaction wrappers for automatic rollback, schema validation, assertions, cleanup, fixtures, migrations, integrity checks, and performance monitoring across PostgreSQL, MySQL, MongoDB, SQLite, Redis using Prisma, Drizzle, Jest, Pytest.

Manage complete database migration workflows: generate timestamped up/down SQL or ORM files, validate schemas, execute migrations, perform rollbacks, and track evolution with version control for PostgreSQL, MySQL, MongoDB, and SQLite using Flyway, Alembic, Prisma, or Knex.

Send messages between CLI AI agents (Claude Code, Codex, Gemini CLI, Copilot CLI) using SQLite as the transport layer, enabling multi-agent collaboration without a daemon or network.

Scaffold and deploy full-stack Cloudflare Workers apps with Hono APIs, Vite+React+Tailwind+shadcn frontends, Drizzle/D1 databases including schemas/migrations/seeds; manage infrastructure via REST API for DNS records, cache purges, WAF rules, R2/KV ops.

Automate Apple Notes on macOS via osascript/JXA/Bash scripts: CRUD notes/folders across accounts, export to Markdown/JSON/SQLite/HTML, debug permissions/errors/timeouts, monitor health/performance, deploy launchd services, migrate data, and secure multi-user access.

Apply 28 prioritized best-practice rules for ClickHouse schema design, query optimization, and data ingestion, with companion skills for running ClickHouse SQL in Python, reviewing schemas and queries, writing Node.js client code, troubleshooting performance issues, and setting up local or cloud ClickHouse environments.

Maintain a shared knowledge commons for AI agents to query, propose, confirm, and flag reusable insights via MCP tools and local SQLite store, preventing rediscovery of failures. Reflect on sessions to mine shareable knowledge like workarounds, approve and submit to the store, and monitor status with tier counts, domains, confidence distribution.

Provides LSP server for SQLite SQL files enabling diagnostics, completions, go-to-definition, hovers, symbol listing, and semantic tokens in your editor. Use companion CLI to format queries, parse AST as tree/JSON, and validate syntax/schema for files, stdin, globs, or embedded SQL in Python/TypeScript.

Optimize SQL queries and analyze execution plans in plain English for PostgreSQL, MySQL, SQLite, and SQL Server. Identify costs and bottlenecks, get index suggestions and rewrites, then compare before/after performance using EXPLAIN ANALYZE.

Build persistent data layers in SwiftUI iOS/macOS apps using Boutique: initialize Stores for CRUD on structured data, persist preferences and secrets via @StoredValue/@SecurelyStoredValue, bind reactively to views with onChange and previews, apply Swift 6 concurrency best practices, and test store setups.

Load, query, and analyze data from files (CSV, Parquet, JSON, Excel, Avro, spatial), S3-compatible storage, or attached DuckDB databases using SQL in Claude Code sessions. Preview schemas/samples without full downloads, convert formats, perform spatial analysis (distances, joins), search docs/session logs, install extensions.

Perform Five Whys root cause analysis to identify issues and solutions, generate Mermaid ERDs from SQL migrations or database schemas, and follow structured 4-step guides for problem-solving and project building through to deployment.

Automate legal document workflows: convert PDFs/scans to Markdown, transcribe audio/video, generate contracts and patent drafts, manage case files, and coordinate multi-agent research—all with Chinese legal domain optimization.

Generate realistic test data from schemas or models, respecting constraints, relationships, and locales, then output as JSON, CSV, SQL INSERTs, or fixtures with validation reports. Seed development databases idempotently via transactional scripts that include cleanup and verify inserted counts for Prisma, Django, and SQL databases.

Interactively design database schemas from application requirements, defining entities, relationships, indexes, and constraints while generating SQL DDL and text-based ERDs. Create visual Mermaid ERDs (saved to docs/erd.md) from existing schemas, ORM models, migrations, or live databases, with optional DBML output and counts of tables/relationships.

Manage the full Airflow data engineering lifecycle: author, test, debug, and deploy DAGs; profile and trace lineage across warehouses; migrate between Airflow versions; and troubleshoot production deployments via CLI.

Manage entire project lifecycles from within Claude Code: save and resume session context, plan and track tasks, run security scans, generate documentation, deploy apps, and automate business workflows — all through markdown-based skills triggered by natural language commands.

Build product metrics frameworks with North Star metrics, KPI trees, and counter-metrics; explain, optimize, and generate SQL queries for PostgreSQL, MySQL, SQLite; create structured dashboard specs including KPIs, charts, and layouts from business questions for BI tools like Looker or Grafana.

Manage an AI-native job queue for Bun with SQLite persistence, including queue setup, workers, cron scheduling, retries, dead-letter queues, and debugging via a specialized agent and an interactive queue manager.

Turn a coding agent into a PR operator: strategize positioning, detect newsjackable stories, and react with on-brand pitches, comments, and press clips using journalist-grade story angles, news monitoring, and crisis-comms frameworks.

Automate end-to-end Japanese income and consumption tax filings for salaried workers with side businesses using blue returns. Assess filing needs via interview, extract data from receipts/invoices/PDFs using OCR, record journal entries to SQLite ledger, compute taxes/depreciation/settlements, prepare e-Tax forms, verify compliance, and guide submission.

Delegate full Swift iOS app development workflows—from TCA architecture design and planning, SwiftUI view implementation, modern concurrency coding, StoreKit integration, to unit testing, code review, debugging, HIG-compliant UI design, and documentation generation—to specialized agents, skills, and commands.

Build and maintain an LLM-curated personal knowledge base from ingested sources (papers, articles, notes) as structured, cross-referenced markdown wiki pages with a typed graph layer for relationships. Supports ingestion, compilation, linting, querying, and scaling to thousands of pages.

Persist Claude Code conversation context to a searchable SQLite database, enabling full-text recall of past sessions, automatic learning extraction, and memory verification against current codebase state.

Prevent codebase knowledge atrophy with adaptive challenges, spaced repetition, and an auto-built knowledge graph from AST parsing. Onboard new developers through structured stages with progress tracking and mastery checks. Capture tribal knowledge via annotations tied to specific code paths.

Accelerate .NET MAUI cross-platform app development by accessing 37 specialized skills that generate code patterns and troubleshoot issues for UI controls, navigation, data binding, animations, theming, authentication, geolocation, notifications, maps, secure storage, permissions, performance optimization, testing, and Xamarin migrations.

Integrate Drizzle ORM with Cloudflare D1 to build type-safe database schemas and relations, manage migrations using Drizzle Kit, execute prepared SQL queries and batch operations, and resolve common D1 errors like transactions and foreign key constraints.

Guides SAP Cloud Application Programming Model development using Capire documentation for CDS model design, service implementation, database configuration (SAP HANA, SQLite, PostgreSQL), Node.js and Java runtimes, Fiori UI integration, deployment to BTP Cloud Foundry and Kyma, and authorization/multitenancy setup.

Turn any chat into a personal AI language tutor that runs daily spaced-repetition review, writing, speaking, reading, and vocabulary drills with adaptive difficulty and progress tracking across multiple languages (Spanish, French, German, Japanese, Korean, Arabic, Dutch).

Set up Cloudflare D1 serverless SQLite databases with interactive wizards, generate validated migrations and schemas, configure Worker bindings, run queries, handle errors like D1_ERROR or statement too long, debug autonomously, and optimize slow queries and indexes.

Configure Nuxt Content v3 as a Git-backed CMS in Nuxt apps to build blogs, documentation sites, and content-driven applications using Markdown or MDC. Enable type-safe content queries, Zod/Valibot schema validation, full-text search, SQL storage with SQLite, and production editing via Nuxt Studio. Deploy seamlessly to Vercel or Cloudflare Pages/D1.

Execute a complete go-to-market pipeline: research target accounts and markets, build and enrich company and contact lists, draft and simulate cold outreach emails, validate and send campaigns via Instantly, and manage responses — all from the command line.

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.

Track real-time Claude Code costs, burn rates, and budgets with zero setup. Set guardrails to pause on overspend, estimate task costs via complexity analysis, generate ASCII charts and exports for sessions/tools/branches, and uncover efficiency scores, waste detection, and model savings.

Accelerate Ruby on Rails app development by generating idiomatic code for Hotwire, GraphQL, background jobs, state machines, admin panels; performing DHH-style reviews, performance audits, data integrity checks; writing RSpec/Minitest; optimizing PostgreSQL/SQLite queries; deploying via Kamal/Docker; researching/building gems—all powered by 50 specialized skills, agents, commands.

Search and retrieve clinical trial data from ClinicalTrials.gov, including study details, locations, and outcomes, with MCP-based integration for programmatic access.

Delegate database engineering to AI agents that design schemas with normalization, indexing, and migrations; optimize SQL queries through execution plans, rewrites, and parameter tuning; and engineer reliability via replication, backups, high availability, monitoring, and failover for PostgreSQL, MySQL, SQLite, MongoDB, Redis, Prisma, and Drizzle.

Build SQLite analysis databases from Java JAR/WAR/Class files to capture classes, methods, calls, inheritance, strings, and Spring components. Execute SQL queries for security audits including vulnerability detection, method/call chain searches, and string analysis.

Deploy and manage Lightning Network infrastructure with container-first tools for running litd nodes, remote signer security, L402 payment-gated APIs, scoped macaroon credentials, and MCP server integration for AI agent connectivity.

Define and execute LLM-powered agentic workflows in VVM DSL, where the LLM serves as the runtime. Generate programs from natural language, statically compile for validation and contract inspection, run with multi-agent coordination, parallel execution, semantic control flow, and state backends like SQLite or Postgres, plus boot, inspect, and registry tools.

Maintain an agent-owned second brain in an Obsidian-compatible Markdown vault, recording observations, preferences, and evidence while enforcing schema rules and logging preference adherence during artifact creation.

Enforce Python code quality with a verified-issue workflow: review FastAPI routing, SQLAlchemy database patterns, PostgreSQL queries, pytest tests, and general Python type safety, using parallel linters (ruff, mypy) and multi-step verification to eliminate false positives.

Manage Bun.js project lifecycle: bundle JavaScript/TypeScript for multiple targets, manage dependencies with Bun package manager, write and run tests with Bun's test runner, and interact with SQLite databases. Includes automation hooks for cleaning up orphaned worktrees.

Run algorithmic SEO audits and track Core Web Vitals, schema markup, backlinks, local maps presence, and AI search visibility across 24 skill areas with automated drift monitoring and baseline regression checking

Run multi-agent AI collaboration workflows in Claude via TeamMCP: connect agents to shared channels, DMs, tasks, project state, and inbox; automate standups, reviews, state updates, context search; bridge to WeChat; route to other AI providers like Ollama.

Orchestrate design doc and research report creation through multi-agent workflows (director, drafter, reviewer) with lifecycle management, multi-round interviews, and TDD execution. Interact with the CAFleet message broker to register agents, send/receive messages, poll inbox, and supervise agent teams with heartbeat and recovery.

Enforce code quality and architectural standards across your projects using a structural code graph for impact-aware reviews, automated audits, and blueprint-driven development. Streamline workflows with specialized agents for fullstack development, data engineering, and real-time monitoring, all integrated with a persistent graph database.

Initialize drt Reverse ETL projects with BigQuery or PostgreSQL, generate YAML sync configs from dbt models or SQL to destinations like Slack, HubSpot, GitHub Actions, or databases, debug auth timeouts and config errors, and migrate pipelines from Census or Hightouch.

Add persistent, cross-session memory to Claude Code that automatically stores and retrieves decisions, patterns, bug fixes, and architectural context using scientific retrieval, with knowledge graph traversal, cognitive profiling, wiki pages, and automated memory maintenance.

Maintain persistent AI context across coding sessions by logging decisions, folder descriptions, and session handoffs to a SQLite database, enabling seamless AI handover and resumed work without losing state.

Orchestrate Claude Code sessions as a kanban board with role-based agents, lifecycle management, and end-to-end testing of web, CLI, HTTP, database, and library APIs via browser automation, snapshot diffing, and log verification.

Automatically cut Claude Code token usage by 60-90% for Odoo development via Rust CLI proxy that filters command outputs, tracks tokens in SQLite, auto-triggers on tool use, and delivers savings analytics dashboard with command stats, periods, and export options. One-command setup installs and registers the hook.

Format selected SQL queries or entire files in your editor with beautification, syntax highlighting, and optimization hints. Supports PostgreSQL, MySQL, and SQLite dialects to improve code readability and catch potential issues.

Generate publication-ready technical articles and social media posts in your author voice, with web research, verified runnable companion code projects (React, Laravel, Node, Python), and multi-language translations. Queue tasks in SQLite for interactive single-article creation or autonomous batch processing.

Migrate Cordova, Ionic Appflow, CocoaPods/SPM, Enterprise SDK, SQLite plugins, and web apps/PWAs to optimized Capacitor setups with Capgo live updates, fast-sql database, framework integrations, and store-ready iOS/Android builds.

Persist and retrieve long-term memory across Claude Code sessions using a local SQLite database. Record bugs, lessons, and project context with full-text search, episode batching, and automatic recall before edits—no external services required.

SDD for Claude Code walks a feature through the full lifecycle — from idea capture through spec, architecture, data model, API design, task breakdown, TDD implementation, review, and shipping — using gated atomic skills and specialized subagents. It maintains an outcome-oriented roadmap, a living glossary, ADRs, and test plans, and surfaces a dashboard UI for pipeline visibility.

Reduce token consumption during large codebase interactions by preprocessing files to remove noise, chunking with AST-aware overlap, hybrid BM25 + vector retrieval, reranking, and compressing top results into citation-rich summary packets that preserve intent and traceability.

Import web articles from WeChat, Zhihu, Juejin, and blogs into SiYuan notes with image handling and duplicate checks. Generate Excalidraw-style diagrams like flowcharts and mind maps, auto-saving as SVG assets. Edit SiYuan-flavored Markdown with wiki links, block embeds, attributes, and SQL queries. Reference core SiYuan concepts, blocks, APIs, and templates.

Read iMessage conversations and new messages from macOS Messages SQLite database, send replies via AppleScript, and manage auto-reply daemons (start, stop, status) for autonomous agents directly in Claude Code workflows.

Scrape local events from Instagram accounts, Facebook pages/groups, and web aggregators into a SQLite database. Update event details via re-scraping and generate dated Markdown newsletters customized by natural language formatting preferences from config sources.

Plan complex projects from PRDs, breaking them into hierarchical tasks with dependencies and milestones, then autonomously execute batches of tasks with dependency resolution, conflict-checked memories, and persistent state in a SQLite database.

Develop full-stack Nette applications with conventions for Latte templates, NEON config, DI, database, forms, architecture, and testing, plus Vite frontend integration and Tracy debugging.

Runs a team of autonomous agents that implement features via TDD, review code with adversarial critiques, and maintain living documentation — all while enforcing project conventions for Go, SQLite, and git workflows.

Run 47 ENCODE genomics research skills and 20 API tools from Claude Code — search experiments, download files with MD5 verification, execute Nextflow/Docker pipelines (ATAC-seq, ChIP-seq, RNA-seq, etc.), cross-reference 14 databases (GTEx, ClinVar, GWAS, gnomAD, Ensembl), track provenance, and generate publication-ready methods sections.

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.

Bootstrap projects with beads/bees task tracking agents that automate git PR workflows, generate conventional commit messages, enforce security scans via gitleaks, guide code reviews and TDD cycles, apply accessibility checks, and produce documentation using essential dev skills.

Orchestrates structured, multi-phase software development workflows with interactive planning, design analysis, code review, issue tracking (Jira/Linear), commit management, and pull request automation.

Perform semantic and keyword search on indexed codebases to find files quickly before reading, maintain persistent memory of sessions, knowledge, and facts across clones and machines, track token savings and activity stats via CLI dashboards, and visualize knowledge graphs, with optional sync to self-hosted web dashboard.

Query and manipulate IDA Pro databases (.idb/.i64) using SQL for reverse engineering workflows: analyze disassembly, decompiled pseudocode, cross-references, strings, functions, and binary data; perform CRUD like annotations, symbol renaming, type application, breakpoint management, and byte patching.

Acquire, clean, compute, and visualize football data from multiple providers (StatsBomb, FBref, Wyscout, etc.) with built-in analytics skills, code review agents, and a searchable MCP documentation server.

Capture thumbs-down feedback from any Claude Code session, automatically convert it into hard prevention rules enforced via PreToolUse hooks that block the same tool call across all future sessions.

Enforces a disciplined software engineering workflow combining DDD, Clean Architecture, and TDD with automated code reviews, quality gates, refactoring plans, and safe Git practices for PHP and TypeScript projects.

Manage personal notes, thinking trails, and knowledge in SQLite databases with provenance tracking, AI-generated breadcrumbs, FTS5 full-text search, and workflow stages. Ingest loose notes into linked inbox chunks, generate thinking snapshots, and review recent activity via headspace briefings.

Extract and analyze data from LinkedIn, Twitter/X, Instagram, Reddit, YouTube, Y Combinator, SEC filings, and the web for lead generation, competitive intelligence, market research, social media analytics, influencer discovery, brand monitoring, and investor research using the anysite MCP server.

Retrieve and restore conversation context across Claude sessions using natural language queries, keyword search, and time-based lookups, with SQLite persistence, auto-tagging, highlight sharing, and shell hook automation.

Enables peer-to-peer direct messaging between active Claude Code sessions on the same machine via a shared SQLite bus, allowing session registration, direct messaging, and broadcast for multi-session coordination.

Run comprehensive SEO audits across technical crawlability, content quality (E-E-A-T), schema markup, backlinks, Core Web Vitals, local SEO, AI search optimization (GEO), and sitemaps—with automated sub-agents, drift monitoring, and direct API integration with Google Search Console, PageSpeed Insights, GA4, Moz, and DataForSEO.

Consult a simulated personal advisory board with Intelligence, Business, Life, and Security councils for deliberating high-impact decisions on tech strategy, business growth, life balance, and risk mitigation. Persist sessions and outcomes in SQLite, review history, follow up on advice, track results, and analyze patterns to refine future recommendations.

Accelerate GPU kernel development with an integrated workflow: query a knowledge base of CUDA, Triton, and CUTLASS patterns, benchmark custom kernels against PyTorch baselines, profile with Nsight Compute, and run iterative optimization loops with correctness checks

Load post-training knowledge patches for Drizzle ORM 1.0 beta (up to 0-beta.19), enabling workflows with consolidated validator imports (Zod, Valibot), Effect Schema support, node-sqlite driver, and .comment() query tagging in TypeScript projects using PostgreSQL, MySQL, or SQLite.

Equip Claude with post-training knowledge of Prisma 5.19+ to 7.3 updates—including ESM rewrite, prisma-client generator, driver adapters, prisma.config.ts, TypedSQL, and SQL comments—for accurate guidance in Prisma projects. Load this skill before starting Prisma development to unlock reliable AI support on recent changes.

Patch Claude's knowledge with SQLx updates from 0.8.3 to 0.9.0-alpha.1, enabling accurate assistance on new features, configs, transactions, and breaking changes for Rust database workflows with PostgreSQL, MySQL, and SQLite.

Work accurately with SQLite 3.46+ up to 3.51 features using AI updated on post-training changes like json_pretty/unistr/jsonb functions, percentile aggregates, multi-arg iif/if, numeric underscores, date modifiers, new C APIs, and DBCONFIG options. Load this skill before SQLite development to avoid outdated knowledge gaps.