SQLite plugins

Run the full academic research lifecycle inside Claude Code — from deep research and evidence mapping through structured writing, citation verification, peer review simulation, revision planning, and multi-format output generation, with a deterministic gate for citation correctness and bilingual abstract support.

Write SQL against warehouses like Snowflake, BigQuery, and PostgreSQL, profile tables, and generate interactive HTML dashboards or publication-quality Python charts — all from natural language, then share results via Google Docs or Jira.

Run a full SEO audit on any website — crawl up to 500 pages, detect business type, and delegate to 15 specialist subagents that analyze technical SEO, content quality, backlinks, schema, Core Web Vitals, local SEO, e-commerce, and AI search visibility, then produce a health score and prioritized action plan.

Develop production-grade Go applications with AI-assisted skills covering project layout, concurrency, profiling, observability, testing, CI/CD, and idiomatic coding patterns across the full development lifecycle.

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.

Develop, deploy, and manage applications on Cloudflare’s platform including Workers, Durable Objects, AI agents, and MCP servers. Scaffold projects, configure resources, audit web performance, and integrate with Cloudflare services via API and CLI.

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.

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

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.

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.

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 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.

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.

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.

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.

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.

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.

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.

Search codebases structurally across 16+ languages using an SQLite + FTS5 index. Find classes, symbols, usages, implementations, and file locations in multi-platform repos via CLI.

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.

Send messages between CLI AI agents (Claude Code, Codex, Gemini CLI, Copilot CLI) using SQLite storage. No daemon or network required, enabling simple cross-agent workflows.

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.

Empowers legal professionals with AI-driven tools for document processing (OCR, PDF-to-Markdown, Word), audio/video transcription, contract review, patent drafting, case analysis, and legal research. Also includes utilities for Git workflow automation, multi-agent orchestration, and content publishing—all within Claude Code.

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.

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

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.

Manage full-stack project lifecycle from Claude Code: save and restore session context, enforce project tiers, split large tasks across parallel sessions, generate database migrations, deploy to Vercel/Netlify/Railway/Hetzner, audit security (OWASP, secrets, RLS, dependencies), and produce client deliverables (quotes, proposals, contracts, invoices).

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.

Auto-syncs Claude Code sessions to a SQLite database with full-text search, persists learnings in a multi-layer memory hierarchy, and provides conversation analytics dashboards for token usage and cost optimization.

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.

Build a live code knowledge graph via AST extraction and AI enrichment, then run adaptive challenges and spaced-repetition quizzes to prevent knowledge atrophy and accelerate onboarding.

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.

Develop SAP CAP applications with full lifecycle support: interactive project setup, CDS modeling, service implementation (Node.js/Java), database configuration (HANA/SQLite/PostgreSQL), OData services, deployment to BTP Cloud Foundry/Kyma, and error diagnostics. Includes CDS language server for real-time syntax and navigation.

Turn a coding agent into a PR operator: strategize positioning, detect newsjackable stories in your space, and react with on-brand pitches and comments

Go-to-market skill bundle for outbound sales — build targeted company lists from ICP and competitive research, enrich contacts with verified emails, design and render cold-email sequences, validate addresses, simulate prospect reactions, and send or reply via Instantly campaigns.

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.

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.

Run daily AI-powered language practice sessions with spaced repetition (SM-2), adaptive exercises, and progress tracking across reading, writing, speaking, and vocabulary drills. Automatically persists learner data to SQLite databases and generates session summaries.

Track and visualize the carbon footprint of Claude Code sessions with daily, yearly, and all-time CO2 emissions data, including shareable PNG report cards for sustainability reporting

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 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.

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.

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.

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.

Search ClinicalTrials.gov, retrieve study details and results, and match patients to eligible trials via an MCP server with STDIO or Streamable HTTP transport.

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.

Orchestrates full software development workflow from idea to production using specialized agents for product management, architecture, coding, QA, security, documentation, and deployment, with persistent memory and automated quality gates.

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.

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.

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 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.

Enforce code quality and architecture standards across full-stack projects with automated audits, impact-aware code reviews, structural code graph analysis, and multi-tenant Supabase patterns. Manages task queues, generates blueprints and changelogs, and scaffolds integrations and MCP servers.

Run comprehensive SEO audits on any website: crawl pages, analyze technical SEO, content quality, backlinks, schema, Core Web Vitals, local SEO, and AI search visibility. Generates prioritized action plans with health scores using 25 specialized sub-skills and 18 sub-agents.

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.

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 Kanban boards — decompose plans into prioritized tasks, assign agent roles, run end-to-end verification across browsers, CLIs, databases, HTTP services, and libraries, then snapshot and diff state to confirm correctness.

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.

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.

Maintain an agent-owned, Obsidian-compatible second brain that records observations, preferences, and evidence, with semantic search, schema management, and codegraph-based code analysis.

Persists coding decisions, bugfixes, and lessons across Claude Code sessions using a local SQLite database with hybrid FTS5 + TF-IDF search, so context is recalled automatically on file edits and skill calls without external services.

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.

Reduce token usage and costs in Claude Code by compressing large codebases and documents into compact, citation-rich context packets using hybrid RAG retrieval (BM25 + vector search), AST-aware chunking, and reranking.

Persistent memory for Claude Code that remembers across sessions automatically — store decisions, architecture rules, bug fixes, and patterns, then retrieve them via scientific retrieval so the AI recalls project context without re-explanation.

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.

Parse PRDs into hierarchical tasks with subtasks, dependencies, milestones, and complexity estimates. Store and query project memories like constraints, decisions, and conventions in SQLite. Execute tasks individually or in autonomous batches, update statuses with dependency resolution, view progress dashboards, and export to JSON or Markdown files.

Recall and manage past Claude Code sessions via the qrec CLI engine: search, re-index, debug session errors, and control the background daemon with automatic environment initialization on startup.

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.

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.

Develop and manage Claude Code skills and plugins with decision trees, session analysis, research verification, and automated workflow enforcement via a prompt hook. Validate, test, and distribute plugins; reflect on sessions to improve skill files.

Capture thumbs-down feedback on AI agent actions, automatically convert repeated failures into prevention rules, and enforce those rules as hard blocks via PreToolUse hooks across all future Claude Code sessions. Includes persistent memory of mistakes and learnings to prevent recurring errors.

Transform Claude into a disciplined senior engineer using DDD, Clean Architecture, and TDD. Enforce architecture reviews, systematic debugging, safe Git workflows, automated code quality gates, and parallel agent teams across PHP/Symfony and React/TypeScript stacks.

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.

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.

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.

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.

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.

Ask natural-language business questions about connected product datasets (CSV, DuckDB, Postgres, BigQuery, Snowflake) to run AI-orchestrated pipelines delivering validated insights, SWD-compliant charts, stakeholder narratives, and Marp slide decks with forecasts, experiments, and root-cause analysis.

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

Structures the entire software development workflow within Claude Code—from issue creation and architecture decisions through implementation planning, multi-lens reviews, and execution—while keeping everything tied to version-controlled project metadata.

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.

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.

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.

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.