Claude skills for SQLite

The 50 strongest of 87 SQLite skills on GitHub. Skills built for SQLite come first; no repository gets more than 3 spots. Each links to its folder; copy it into ~/.claude/skills/ to use it.

  1. sqlite ops

    Patterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.

    aiskillstore/marketplace★ 446No licence statedFolder: sqlite-ops

  2. bun sqlite

    Use for bun:sqlite, SQLite operations, prepared statements, transactions, and queries.

    secondsky/claude-skills★ 240MITFolder: bun-sqlite

  3. mobile storage sqlite powersync

    PowerSync offline-first sync engine on SQLite for React Native - schema definition, watched queries, CRUD operations, backend connectors, sync rules, conflict resolution, attachments

    agents-inc/skills★ 26MITFolder: mobile-storage-sqlite-powersync

  4. opencode qa

    QA opencode itself, per case: verify the CLI/terminal (opencode run, db, serve, export), prove a specific plugin hook/action/event fired via the SSE event stream, smoke-test the TUI under tmux, and investigate sessions in opencode's SQLite DB by id,…

    code-yeongyu/oh-my-openagent★ 70kLicence: see repoFolder: opencode-qa

  5. hive.colony progress tracker

    Claim tasks, record step progress, and verify SOP gates in the colony SQLite queue. Applies when your spawn message includes a db_path field.

    aden-hive/hive★ 11kApache-2.0Folder: colony-progress-tracker

  6. deepchat data import

    Help developers build third-party tools that import, inspect, migrate, or analyze DeepChat data. Use when Codex needs to work with DeepChat provider configuration, model configuration, MCP/app settings, sessions, messages, legacy chat data, `agent.db`,…

    ThinkInAIXYZ/deepchat★ 6.4kApache-2.0Folder: deepchat-data-import

  7. audit flow

    Interactive system flow tracing across CODE, API, AUTH, DATA, NETWORK layers with SQLite persistence and Mermaid export. Use for security audits, compliance documentation, flow tracing, feature ideation, brainstorming, debugging, architecture reviews, or…

    zebbern/claude-code-guide★ 4.7kMITFolder: audit-flow

  8. database scout

    Explore SQLite and PostgreSQL databases: list tables, inspect schemas (columns/types/constraints), preview data, generate Mermaid ER diagrams, and run safe read-only queries. Triggered by requests to explore a database, view table structures, describe…

    zebbern/claude-code-guide★ 4.7kMITFolder: database-scout

  9. sql insight

    Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL. Triggered when users ask to convert questions into SQL, improve slow queries, tune indexes, analyze execution plans, or mention keywords…

    zebbern/claude-code-guide★ 4.7kMITFolder: sql-insight

  10. golang database

    Comprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling. Use when writing,…

    samber/cc-skills-golang★ 3.7kMITFolder: golang-database

  11. wiki builder

    Start, structure, and grow a persistent research wiki indexed in pro-workflow's SQLite knowledge base. Each wiki is a folder of markdown pages with provenance, plus a shadow FTS5 index so any session can recall it. Use when the user says "start a wiki",…

    rohitg00/pro-workflow★ 2.9kNo licence statedFolder: wiki-builder

  12. wiki query

    Query pro-workflow wikis via SQLite FTS5 BM25 retrieval. Returns top-K passages with citations. Use when answering a question that any of the user's wikis already covers, when the user says "what does the wiki say about X", "ask wiki", "search wikis", or…

    rohitg00/pro-workflow★ 2.9kNo licence statedFolder: wiki-query

  13. data layer footguns

    Room/SQLite, DataStore and repository traps: migrations, NOT IN with NULLs, LIKE escaping, delete order, local-time bucketing, imports, caching, paging. Use before writing a query or migration, or when data comes back wrong.

    maxrave-dev/kotlin-footguns★ 1.8kGPL-3.0Folder: data-layer-footguns

  14. database schema designer

    Design relational schemas from requirements with normalization, migrations, ERDs, RLS policies, and indexes for PostgreSQL, MySQL, and SQLite. Use when designing new features, reviewing schemas, or adding multi-tenancy.

    borghei/Claude-Skills★ 1kLicence: see repoFolder: database-schema-designer

  15. brain

    Use when the user says brain, project knowledge, what do we know about, open tasks, or recent decisions, or runs /brain or /brain-update. SQLite project_brain.db tracker for entities, relationships, tasks, threads, decisions, events.

    coco-research/coco★ 795Licence: see repoFolder: brain

  16. hackernews intel

    Monitors Hacker News for user-configured keywords, deduplicates against a local SQLite cache, and sends Slack alerts for new matching posts. Use when asked to monitor Hacker News for mentions, track keywords on HN, get alerts when something is posted about…

    Varnan-Tech/opendirectory★ 686MITFolder: hackernews-intel

  17. yc jobs scraper

    Scrape daily job listings from YCombinator's Workatastartup platform without duplicates. Use this skill when asked to scrape YC jobs, update the YC companies list, or retrieve the latest startup jobs. It handles authentication, extracts company slugs via…

    Varnan-Tech/opendirectory★ 686MITFolder: yc-jobs-scraper

  18. wx favorites report

    微信收藏可视化:从加密的微信本地数据库端到端解密、解析,生成交互式 HTML 可视化报告。 触发词:/wx-favorites-report、微信收藏可视化、收藏报告、收藏分析 支持输入:加密/解密后的 Favorite.db(SQLite)或 CSV/JSON 导出文件

    zhuyansen/wx-favorites-report★ 642MITFolder: wx-favorites-report

  19. using relational databases

    Relational database implementation across Python, Rust, Go, and TypeScript. Use when building CRUD applications, transactional systems, or structured data storage. Covers PostgreSQL (primary), MySQL, SQLite, ORMs (SQLAlchemy, Prisma, SeaORM, GORM), query…

    ancoleman/ai-design-components★ 525MITFolder: using-relational-databases

  20. health data

    Query Apple Health SQLite database for vitals, activity, sleep, and workouts. Supports Markdown, JSON, and FHIR R4 output formats. This skill should be used when analyzing health metrics, generating health reports, answering questions about fitness or…

    glebis/claude-skills★ 402MITFolder: health-data

  21. init tauri app

    Scaffold a new Tauri v2 project with the cenno/cull house conventions — delegates boilerplate to `npm create tauri-app`, then layers an opinionated core plus opt-in modules (CLI+MCP, SQLite, tray/updater, release/preflight, Swift sidecar). Use when the…

    glebis/claude-skills★ 402MITFolder: init-tauri-app

  22. drizzle orm patterns

    Provides comprehensive Drizzle ORM patterns for schema definition, CRUD operations, relations, queries, transactions, and migrations. Proactively use for any Drizzle ORM development including defining database schemas, writing type-safe queries,…

    giuseppe-trisciuoglio/developer-kit★ 366MITFolder: drizzle-orm-patterns

  23. graph build

    Builds or updates the code knowledge graph via tree-sitter AST and SQLite. Use when setting up the graph before search or blast-radius analysis.

    athola/claude-night-market★ 343MITFolder: graph-build

  24. sealeap apollo competitor monitor

    建立 Amazon 竞品核验、时间快照、价格与 Listing 变化记录,以及本地 HTML 总览。用于竞品监控、排名复盘、历史快照和变化分析;支持授权采集后导入 SQLite。

    xjli360/sealeap-amazon-skills★ 338MITFolder: sealeap-apollo-competitor-monitor

  25. codex log guard

    Diagnose excessive Codex local SQLite diagnostic log writes with read-only evidence by default. Use when a user mentions logs_2.sqlite, logs_2.sqlite-wal, block_log_inserts, SSD/TBW wear, or explicitly asks to protect, clean up, verify, or restore Codex…

    majiayu000/spellbook★ 288MITFolder: codex-log-guard

  26. Drizzle ORM Testing

    Testing patterns for Drizzle ORM covering migration testing, query builder testing, transaction testing, and database integration testing with PostgreSQL, SQLite, and MySQL.

    PramodDutta/qaskills★ 244MITFolder: drizzle-orm-testing

  27. bun drizzle integration

    Use when integrating Drizzle ORM with Bun's SQLite driver for type-safe schema definitions and migrations.

    secondsky/claude-skills★ 240MITFolder: bun-drizzle-integration

  28. cloudflare d1

    Cloudflare D1 serverless SQLite on edge. Use for databases, migrations, bindings, or encountering D1_ERROR, statement too long, too many requests queued errors.

    secondsky/claude-skills★ 240MITFolder: cloudflare-d1

  29. frappe core search

    Use when implementing search functionality in Frappe v14-v16. Covers link field search (search_link), global search, FullTextSearch (Whoosh), SQLiteSearch FTS5 [v15+], Awesomebar customization, search_fields configuration, custom search queries, and…

    Impertio-Studio/Frappe_Claude_Skill_Package★ 198Licence: see repoFolder: frappe-core-search

  30. skill base web deploy

    Skill Base server deployment guide. Covers starting the Skill Base server (npx skill-base), Docker configuration, port mapping, SQLite database backup, and platform capabilities (collections, tags, GitHub import). For deploying and operating the Skill Base…

    ginuim/skill-base★ 121No licence statedFolder: skill-base-web-deploy

  31. cloudflare workers expert

    Expert guide for Cloudflare Workers ecosystem — Workers, D1 (SQLite at edge), KV, R2 (S3-compatible storage), Queues, Durable Objects, Hyperdrive, and Workers AI / Panduan ahli ekosistem Cloudflare Workers — Workers, D1, KV, R2, Queues, Durable Objects,…

    roedyrustam/vibes-plug★ 116MITFolder: cloudflare-workers-expert

  32. pwa offline first expert

    Expert guide for Local-First & Offline-First architectures, CRDT conflict-free sync (RxDB, ElectricSQL, PowerSync), OPFS SQLite, Service Worker v3, and PWABuilder deployment / Panduan ahli arsitektur Offline-First & Local-First PWA.

    roedyrustam/vibes-plug★ 116MITFolder: pwa-offline-first-expert

  33. review lessons

    Library of lessons from past build-review loops — not a stage. Use when a review or fix round hits a specific case: a reviewer BLOCKING that contradicts the brief, a test that passes but checks nothing, a feature dead in production, SQLite/WAL migrations,…

    moonlight-lupin/agent-skills★ 113MITFolder: review-lessons

  34. library rag

    Semantic search over a personal library using Nemotron-3-Embed-1B embeddings + sqlite-vec. Index books, documents, any text corpus; query by meaning. Includes EPUB→Markdown conversion and MCP server for auto-available search tools.

    moonlight-lupin/agent-skills★ 113MITFolder: library-rag

  35. payloadcms ops

    Payload CMS 3 (Next.js-native) architecture - collections, globals, fields, access control, hooks, Local API, storage adapters, and database (Postgres/MongoDB/SQLite). Use for: payload, payloadcms, payload cms, payload 3, collection config, access control,…

    0xDarkMatter/claude-mods★ 78MITFolder: payloadcms-ops

  36. pigeon

    Inter-session pmail - send and receive messages between Claude Code sessions running in different project directories. Uses global SQLite database at ~/.claude/pmail.db. Triggers on: mail, pmail, send message, check mail, inbox, inter-session, message…

    0xDarkMatter/claude-mods★ 78MITFolder: pigeon

  37. portable schema generator

    Emit Postgres.sql and SQLite.sql from a single schema spec so tools work across both drivers without duplicating DDL by hand. Use when designing a schema that needs to support both shared Postgres deployments and zero-config SQLite. Reduces two-file sync…

    Tibsfox/gsd-skill-creator★ 71Licence: see repoFolder: portable-schema-generator

  38. atera

    Every Atera RMM + PSA endpoint, plus a local SQLite mirror that answers fleet-health, SLA, and book-of-business questions no single API call can. Trigger phrases: `which atera agents are offline`, `atera tickets about to breach sla`, `atera book of…

    Servosity/msp-skills★ 64Licence: see repoFolder: atera

  39. autotask

    Every Autotask entity at the command line, plus a local SQLite mirror that answers ticket-aging, workload, unbilled-time, and account-360 questions no other Autotask tool can. Trigger phrases: `list autotask tickets`, `autotask company 360`, `who is…

    Servosity/msp-skills★ 64Licence: see repoFolder: autotask

  40. betterstack

    Every Better Stack Uptime feature, plus an offline SQLite mirror and cross-resource fleet analytics - what's down and who's paged, coverage gaps, MTTA/MTTR, flapping, on-call gaps, and status-page drift - that the API alone can't answer. Trigger phrases:…

    Servosity/msp-skills★ 64Licence: see repoFolder: betterstack

  41. claude peers

    Discover, message, and coordinate AI coding agents (Claude Code, Codex CLI) running on the same machine via a shared Unix socket broker backed by SQLite. The broker wakes recipients natively (Claude inbox socket, codex queue) and turn-boundary hooks catch…

    tdimino/claude-code-minoan★ 41MITFolder: claude-peers

  42. sql expert

    Expert SQL query writing, optimization, and database schema design with support for PostgreSQL, MySQL, SQLite, and SQL Server. Use when working with databases for: (1) Writing complex SQL queries with joins, subqueries, and window functions, (2) Optimizing…

    AutumnsGrove/ClaudeSkills★ 37No licence statedFolder: sql-expert

  43. turso db

    Install, configure, and work with Turso DB — an in-process SQLite-compatible relational database engine written in Rust. Use when the user needs to (1) install Turso DB, (2) create or query databases with the tursodb CLI shell, (3) use Turso from…

    av/skills★ 28MITFolder: turso-db

  44. artiboard

    Set up, adapt or upgrade a shared task board for people and their coding agents, either as a private claude.ai artifact with its own database (Claude only) or on a self-hosted site (SQLite or Supabase, on a team domain or this computer) that Claude Code…

    yulmucoffee/artiboard★ 27MITFolder: artiboard

  45. api baas turso

    Edge-hosted SQLite database with libSQL driver and embedded replicas

    agents-inc/skills★ 26MITFolder: api-baas-turso

  46. api database knex

    SQL query builder for PostgreSQL, MySQL, SQLite, and MSSQL -- fluent queries, schema builder, migrations, seeds, transactions, raw queries

    agents-inc/skills★ 26MITFolder: api-database-knex

  47. db query plan analyzer

    Reads `EXPLAIN` / `EXPLAIN ANALYZE` output from PostgreSQL, MySQL, or SQLite - identifies the dominant cost (sequential scan, nested loop, sort spill, missing index, type-cast preventing index use), proposes the specific index or query rewrite to fix it,…

    testland/qa★ 13MITFolder: db-query-plan-analyzer

  48. arch

    Read the system-architect map: a deterministic catalog of everything the setup is made of (vault, import scripts, scheduled tasks, MCP servers, SQLite databases, hooks, skills, dashboards), what is healthy and what fell off. Consult it before changing…

    tonydzi/second-brain-starter-kit★ 12MITFolder: arch

  49. cursor repair

    Repair the Cursor editor when it crashes, fails to launch, or new Agent chats break. Use with a Request ID, fresh logs, CursorRule.parse_error or invalid UTF8 in skill frontmatter, or a better-sqlite3 NODE_MODULE_VERSION mismatch. Finds a reproducible…

    tonydzi/second-brain-starter-kit★ 12MITFolder: cursor-repair

  50. mutation testing

    Validates test quality beyond coverage: uses Claude subagents to generate intelligent mutations for source code, runs them via the project's native test runner (pytest, jest, vitest, mocha, go test), prints a structured summary, generates mutation-todos.md…

    agentlogbooks/logbooks★ 8No licence statedFolder: mutation-testing

Claude skills for SQLite: what people ask

Is there a Claude skill for SQLite?

There are 87 of them, spread over 41 repositories on GitHub. Named for it and most starred: sqlite ops (aiskillstore/marketplace, ★ 446), bun sqlite (secondsky/claude-skills, ★ 240) and mobile storage sqlite powersync (agents-inc/skills, ★ 26). Stars rate the repository a skill sits in, not the skill.

How do I install a Claude skill for SQLite?

For SQLite, take the sqlite-ops folder from aiskillstore/marketplace (the folder that holds SKILL.md) into ~/.claude/skills/ to use it in every Claude Code project, or into .claude/skills/ for one project. In the Claude apps, zip that folder and upload it as a custom skill in settings.

Are these SQLite skills official?

No. None of the 87 SQLite skills comes from Anthropic's own skills repository, so all of them are community-made across 41 repositories.

Can I use these SQLite skills at work?

Of the 50 SQLite skills listed here, 35 sit in repositories under an open licence such as MIT or Apache 2.0, and 6, such as sqlite ops and wiki builder, state no licence at all, which legally means you may not reuse them. Check the licence file before you copy one into company work.

What should I check before installing a SQLite skill?

A SQLite skill is instructions Claude follows, and it can bundle scripts Claude runs, so read SKILL.md and every script first: for sqlite ops, that is everything in the sqlite-ops folder. 1 of the 50 here, mutation testing, come from repositories with under 10 stars, so few people have looked at it. Red flags: piping a download into a shell, sending files to a URL, and instructions to hide what it does from you.

Are these SQLite skills maintained?

76 of the 87 SQLite skills sit in repositories that changed in the 30 days before 31 Oct 2026.

More topics: every “Claude skills for…” page.