Sqlite AI Agent Skills

SQL query optimization patterns including EXPLAIN plan analysis, index strategies, query rewriting, and N+1 query prevention. Use when optimizing slow database queries, analyzing query performance, designing indexes, or debugging database bottlenecks. Works with PostgreSQL, MySQL, SQLite, and other SQL databases. Typical improvements: 10x-1000x query speedup.

Token Optimizer MCP is a Model Context Protocol (MCP) server that reduces context window usage by 60-90% through intelligent caching, compression, and smart tool replacements. By storing compressed content externally in SQLite and providing optimized alternatives to standard tools, the server helps you maximize your available context window. Production Results: 60-90% token reduction across 38,000

Anyquery is a SQL query engine that allows you to run SQL queries on pretty much anything. It supports querying files, databases, and apps (e.g. Apple Notes, Notion, Chrome, Todoist, etc.). It's built on top of SQLite and uses plugins to extend its functionality. It can also connect to LLMs (e.g. ChatGPT, Claude, Cursor, TypingMind, etc.) to allow them to access your data. Finally, it can act as a

Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.

Fast, accurate codebase intelligence for AI coding agents. ctx++ is an MCP (Model Context Protocol) server that gives AI agents precise, structured understanding of large codebases. It extracts symbols using native tree-sitter parsing, indexes them in SQLite with both full-text and vector search, and traces call graphs to automatically map how features are assembled across files -- no hand-maintai

This is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities. - Complete CRUD operations (Create, Read, Update, Delete) - Database exploration and introspection - Execute custom SQL queries Define the command in your IDE's MCP Server settings: e.g. Cursor: e.g. VSCode: Your database path must be provided as an argument. Get detailed information

What a repository knows about itself. rag-rat is a local repo-intelligence index and MCP server for coding agents. It keeps source files read-only, writes only its own SQLite database, and answers with provenance on every result — current source, the code graph, git/GitHub history, and durable, source-anchored repo memories that persist across sessions and agents. Every coding harness already has

Create and review Cloudflare Durable Objects. Use when building stateful coordination (chat rooms, multiplayer games, booking systems), implementing RPC methods, SQLite storage, alarms, WebSockets, or reviewing DO code for best practices. Covers Workers integration, wrangler config, and testing with Vitest.

A Go MCP server for D&D campaign state management, dice rolling, and session memory. - Serves a Model Context Protocol (MCP) toolset over stdio or streamable HTTP. - Stores campaign data in per-campaign SQLite databases. - Tracks characters, plot events/hooks, world flags, roll history, checkpoints, and session summaries. - Generates session briefs and markdown recaps for fast DM context restorati

Local-first MCP runtime for multi-agent consensus guard workflows — AI code review, weighted voting, HITL approval gates, and full observability on SQLite. MCP stdio mode (Claude Desktop, OpenClaw, etc.): Prerequisites: Node.js 20+, npm 10+. Optional: gh CLI (for GitHub PR triggers), OpenAI API key (falls back to deterministic heuristics without one). Any model accessible via the OpenAI or Anthrop

Watch AG-UI + LangChain demo - SSE - Server-Sent Events for connection state and observability updates - Flexible Storage - Redis, SQLite, File System, or In-Memory backends - Serverless - Works in serverless environments (Vercel, AWS Lambda, etc.) - React Hook - useMcp hook for easy React integration - Vue Composable - useMcp composable for Vue applications - MCP Protocol - Support for tools, pro

MCP server for PostgreSQL, MySQL, and SQLite. Gives AI assistants secure database access via Model Context Protocol. Works with Claude Desktop, Claude Code, Cursor, Cline, and any MCP-compatible client. Add to your MCP client config file (see config locations below): This creates three database connections: analytics (read-only), inventory, and cache. Connection URL formats: URLs support ${VAR} sy

A local vector memory explorer with a modern UI inspired by Supabase and Pinecone. Browse, search, visualize and manage the SQLite-vec database created by MCP Memory Service . I'm a sysadmin by trade, not a developer. My coding background is some C++ from many years ago. I built memviz entirely through vibe coding with Claude Code as a way to test AI-assisted development workflows. The whole thing

A Model Context Protocol (MCP) server that allows AI assistants like Claude to read notes from the Bear note-taking app. This implementation connects directly to the Bear SQLite database in a read-only mode, ensuring your notes remain safe and unmodified. That's it! The server will start running and connect to your Bear database. - macOS with Bear app installed - Node.js 18 or higher Add this to y

An MCP server that provides safe, read-only access to SQLite databases through Model Context Protocol (MCP). This server is built with the FastMCP framework, which enables LLMs to explore and query SQLite databases with built-in safety features and query validation. - Python 3.6+ - SQLite database file (path specified via environment variable) Install all required dependencies: - fastmcp: Framewor

Zaturn: Your Co-Pilot For Data Analytics & Business Insights Zaturn provides tools that enable AI models to run SQL, so you don't have to. It can be used as an MCP or as a web interface similar to Jupyter Notebook. Zaturn can currently connect to the following data sources: - SQL Databases: PostgreSQL, SQLite, DuckDB, MySQL, ClickHouse, SQL Server, BigQuery - Files: CSV, Parquet Request data sourc

An MCP server that provides full text search for code declarations. Uses SQLite with FTS5 and universal ctags to index and search functions, classes, structures, enums, and other code elements. Supports all languages that ctags supports including Python, C, Go, C++, JavaScript, Rust, Java, and many others. - Python 3.13 - Universal Ctags 6.2.0 - SQLite with FTS5 support (included in Python 3.13) J

This project is a Model Context Protocol (MCP) server that provides access to the Bear Notes. Bear stores notes on SQLite database. This MCP server runs some SQL commands to access this notes. - Read notes - Search notes by text - List all tags Update your claudedesktopconfig.json When the server is started, the following MCP tools become available: - getnotes: Retrieves all notes - gettags: Lists