sqlite-query
Original：🇺🇸 English
Translated
Query SQLite databases, inspect schemas, and explain queries via MCP. Use when working with local SQLite databases.
5installs
Added on
NPX Install
npx skill4agent add ofershap/mcp-server-sqlite sqlite-queryTags
Translated version includes tags in frontmatterSKILL.md Content
View Translation Comparison →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 |
|---|---|
| Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table. |
| Full schema: all tables with columns, types, and row counts |
| Detailed info for a single table: columns, constraints, row count |
| Run EXPLAIN QUERY PLAN for query optimization |
| List .db, .sqlite, .sqlite3 files in a directory |
Workflow
- to find .db files in the project
list_databases - to understand the full database structure
schema - for detailed column info on specific tables
table_info - to run SELECT queries and inspect data
query - to optimize slow queries
explain
Key Patterns
- Read-only by default — only SELECT, PRAGMA, EXPLAIN, and WITH are allowed
- Pass in tool args to enable INSERT, UPDATE, DELETE
readonly: false - returns everything at once — use it first to understand the database
schema - returns tabular results — ideal for exploration and debugging
query - 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