SQLite plugins

Run a production-grade academic research pipeline: deep research, paper writing, integrity checks, peer review simulation, revision with response-to-reviewers, and finalization. Includes citation verification, literature review generation, bilingual abstract creation, and format conversion between LaTeX, DOCX, PDF, and Markdown.

Write and optimize SQL across data warehouses, profile datasets, and generate interactive dashboards or publication-quality charts from queries or files. Automates data analysis with natural language queries and connects to analytics platforms like Amplitude and Hex.

Run comprehensive SEO audits on entire sites — technical crawl, content quality, schema, Core Web Vitals, backlinks, local/maps presence, e-commerce, hreflang, sitemaps, and GEO/AI search visibility — then generate scored action plans and content briefs, all from Claude Code.

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.

Build, deploy, and manage the full Cloudflare platform — Workers, Durable Objects, AI agents, email, Zero Trust, and web performance — with skills for scaffolding projects, writing production code, managing infrastructure via Wrangler CLI and API, and auditing Core Web Vitals.

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.

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.

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.

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.

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.

Send messages between CLI AI agents (Claude Code, Codex, Gemini CLI, Copilot CLI) using SQLite — no daemon or network required. Enables cross-agent communication for multi-agent workflows entirely on the command line.

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.

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.

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.

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.

Search code structurally across 16+ languages using SQLite + FTS5 indexes to find classes, symbols, usages, implementations, and file locations in multi-platform repositories.

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.

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.

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.

Automate legal document processing, audio/video transcription, web scraping, and case management with a skill suite for OCR, PDF manipulation, contract review, patent drafting, git workflow, and legal research, tailored for Chinese legal professionals.

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

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

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.

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.

Turn your coding agent into a PR operator — generate journalist-quality story angles from company updates, detect newsjackable stories in your space, and react with on-brand pitches and comments. Includes media monitoring, pitch critique, journalist list management, and stylometry-based voice enforcement.

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.

Persists learnings across sessions using a hierarchical memory system with SQLite-backed full-text search, automatically syncs conversations, detects stale knowledge, and uncovers uncaptured patterns from past chats. Includes token usage analytics and conversation retrospectives.

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.

Learn and retain codebase knowledge through adaptive challenges, spaced repetition, and structured onboarding. Extracts AST-based knowledge graphs, captures tribal knowledge as annotations, and runs multi-question gauntlet sessions to test understanding.

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 Cloud Application Programming Model (CAP) applications with full lifecycle support: model CDS entities and services, implement OData and event handlers in Node.js/Java/TypeScript, deploy to SAP BTP Cloud Foundry or Kyma, and debug with diagnostics and performance tuning.

Deliver personalized language tutoring with spaced repetition, adaptive exercises, and progress tracking—turn any AI assistant into a daily language coach supporting reading, writing, speaking, vocabulary, and review sessions.

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.

Automate go-to-market operations: build targeted company lists, enrich contacts with verified emails and LinkedIn data, draft cold outreach messages, render email sequences, and manage campaign sending and replies via Instantly.

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.

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.

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.

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.

Maintain a persistent, agent-writable second brain knowledge base that integrates with Obsidian, supports semantic search, code analysis, and schema management for both human and AI agent use.

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.

Execute full-site SEO audits with parallel subagents, covering technical crawlability, Core Web Vitals, schema, content E-E-A-T, backlinks, local/maps presence, and AI search visibility. Regressions are tracked via baselines, and GEO readiness is assessed for AI overviews and LLM citations.

Orchestrates multi-agent teams (Director, Drafter, Reviewer, Programmer, Tester) that collaborate on design documentation, implementation, and research reports using a message broker CLI and SQLite-backed coordination layer.

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.

Extends Claude Code with session persistence, custom commands, skills, agents, hooks, and output styles for managing complex development workflows across git operations, testing, security, and deployment.

Orchestrate Claude Code sessions as a Kanban board with agent lifecycle hooks, role-based task assignment, and automated verification of web pages, CLI tools, APIs, databases, and libraries, plus fuzzy exploration and plan decomposition into worker-ready tickets.

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.

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.

Give Claude Code persistent, cross-session memory that automatically stores and retrieves decisions, patterns, architecture rules, and bugs. Includes knowledge graphs, cognitive profiling, automated maintenance, and full MCP lifecycle hooks for scientific retrieval across projects.

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.

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.

Optimizes Claude Code interactions by reducing token usage and costs through hybrid retrieval (BM25 + vector search) and summarization, compressing large codebases into compact context packets while preserving key information for reasoning.

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.

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.

Develop Nette Framework applications with Latte templating and NEON config, covering frontend (Vite, Tailwind, JS/TS) and backend (presenters, DI, database, forms), plus testing (Tester), debugging (Tracy), and data validation (Schema).

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.

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.

SDD implements a complete spec-driven development pipeline for Claude Code: survey a codebase or bootstrap greenfield, walk gated stages from idea capture → spec → architecture → data model → OpenAPI contract → task breakdown → TDD implementation → review → ship, while maintaining a living roadmap (Now/Next/Later). Every stage hard-refuses to proceed if the previous artifact is missing, and the depth of Q&A and ideation is tunable.

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.

Create, validate, debug, and publish Claude Code plugins and skills using a structured toolkit with decision trees, schema validation, session reflection, and source verification.

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.

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.

Develop, review, and deploy Go projects with conventions for architecture, testing, and git workflow, while also building interactive web UIs with Datastar, performing security reviews, fine-tuning AI models, and maintaining living documentation and experimental optimization loops.

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.

Run comprehensive SEO audits across technical SEO, content quality (E-E-A-T), schema markup, image optimization, sitemaps, AI search visibility (GEO), local SEO, and backlinks, then generate prioritized action plans and reports using live data from Google Search Console, PageSpeed Insights, 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

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.