Sqlite Query
- 1 installs
- 3 repo stars
- Updated March 10, 2026
- ofershap/mcp-server-sqlite
Queries SQLite databases over MCP with read-only default: run SQL, inspect schema and table info, EXPLAIN query plans, and list database files.
About
This skill provides MCP tools to run SELECT queries, inspect schema and per-table details, run EXPLAIN QUERY PLAN, and list .db files, read-only by default. A developer uses it to explore and optimize local SQLite databases.
- Read-only by default; readonly:false enables writes
- explain runs EXPLAIN QUERY PLAN for optimization
Sqlite Query by the numbers
- 1 all-time installs (skills.sh)
- Ranked #765 of 911 Databases skills by installs in the Skillselion catalog
- Data as of Aug 4, 2026 (Skillselion catalog sync)
npx skills add https://github.com/ofershap/mcp-server-sqlite --skill sqlite-queryAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 1 |
|---|---|
| repo stars | ★ 3 |
| Last updated | March 10, 2026 |
| Repository | ofershap/mcp-server-sqlite ↗ |
What it does
Queries SQLite databases over MCP with read-only default: run SQL, inspect schema and table info, EXPLAIN query plans, and list database files.
Files
SQLite Query via MCP
Use this skill when you need to query SQLite databases, inspect schemas, or optimize queries. Read-only by default for safety.
Available Tools
| Tool | What it does |
|---|---|
query | Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table. |
schema | Full schema: all tables with columns, types, and row counts |
table_info | Detailed info for a single table: columns, constraints, row count |
explain | Run EXPLAIN QUERY PLAN for query optimization |
list_databases | List .db, .sqlite, .sqlite3 files in a directory |
Workflow
1. list_databases to find .db files in the project 2. schema to understand the full database structure 3. table_info for detailed column info on specific tables 4. query to run SELECT queries and inspect data 5. explain to optimize slow queries
Key Patterns
- Read-only by default — only SELECT, PRAGMA, EXPLAIN, and WITH are allowed
- Pass
readonly: falsein tool args to enable INSERT, UPDATE, DELETE schemareturns everything at once — use it first to understand the databasequeryreturns tabular results — ideal for exploration and debugging- Database path is passed per-tool call, not globally configured
Safety
- Read-only mode is on by default — no accidental mutations
- Confirm with the user before enabling write mode (
readonly: false) - Large result sets are truncated — use LIMIT in queries for efficiency
Related skills
Lark BaseLet their coding agents read from, write to, and query structured data stored in Lark Base (Feishu) spreadsheets and databases.493k
Azure KustoRun fast KQL queries against Azure Data Explorer for log analytics, telemetry, and time-series data.484k1.3k
Lark SheetsCreate, read, update, and export spreadsheets inside Lark (Feishu) directly from their AI coding agent.389k15.9k
Supabase Postgres Best PracticesAutomatically apply Supabase Postgres performance rules during query writing, schema design, and database optimization.313k2.4k
Firebase Data ConnectGenerate complete, production-ready Firebase Data Connect GraphQL schemas and queries for complex relational data models.112k392Firebase FirestoreAdd Cloud Firestore read/write capabilities to an Android Kotlin app using the official Firebase SDK.77k392