io.github.spences10/mcp-sqlite-tools
NPM · MCP-SQLITE-TOOLS
MCP server for local SQLite database operations
Available components
Last scanned (2 hours ago)
Scores higher than 50% of npm servers
Category Databases
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security97
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- No install/post-install scripts declared.Pass
- 27 of 50 dependencies flagged as unhealthy (1 deprecated). View diagnostics → Partial
Provenance & Transparency45
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 43 days ago).Pass
- Security-disclosure policy not yet verified: we couldn't inspect the source repository.Unverified
Schema Quality & AI Usability51
- AI-judged instruction clarity (fair).Partial
- Tool/resource definitions use about 676 tokens (~35/item across 19 items; 19 tools + 0 resources), lean.Pass
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management100
- No destabilizing schema changes in the last 30 days.Pass
Tool Coverage67
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 0% of tool parameters carry a description.Fail
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 4 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "drop_table" implies "drop" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 19 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a current MCP spec version (2026-07-28).Pass
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 5 Nov 26 0
- Security disclosure: fail → unverified ▼ functional
- 4 Nov 26 0
- Stability: 0.97 → pass security
- 3 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 93 to 97. That category is still filling its 30-day observation window: 28 days of observed history at the previous scan, 29 at this one. The score rises as the window fills, whether or not the server changes.
- 2 Nov 26 −1
- Stability: pass → 0.93 functional
- 27 Oct 26 0
- Stability: 0.97 → pass security
- 26 Oct 26 0
- Stability: pass → 0.97 functional
- 22 Oct 26 0
- Security disclosure: unverified → fail ▼ functional
- 20 Oct 26 0
- Security disclosure: fail → unverified ▼ functional
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 5 Nov 2026 · Analysed npm/mcp-sqlite-tools@0.0.11
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | npm |
Background: How many MCP packages publish verified provenance →
Dependencies 50 packages
| Packages resolved | 50 |
|---|---|
| Deprecated | 1 |
| Stale | 26 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
backup_database ✓ SAFE: Create a backup copy of a database ~35
✓ SAFE: Create a backup copy of a database
| Name | Type | Req | Description |
|---|---|---|---|
| backup_path | string | – | – |
| source_database | string | – | – |
No output schema declared.
No examples provided.
begin_transaction ⚠️ TRANSACTION: Begin a database transaction ~26
⚠️ TRANSACTION: Begin a database transaction
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
bulk_insert ⚠️ DESTRUCTIVE: Insert multiple records efficiently in batches ~51
⚠️ DESTRUCTIVE: Insert multiple records efficiently in batches
| Name | Type | Req | Description |
|---|---|---|---|
| batch_size | number | – | – |
| data | array | yes | – |
| database | string | – | – |
| table | string | yes | – |
No output schema declared.
No examples provided.
close_database ✓ SAFE: Close a database connection ~23
✓ SAFE: Close a database connection
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
commit_transaction ✓ TRANSACTION: Commit the current database transaction ~25
✓ TRANSACTION: Commit the current database transaction
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
create_table ⚠️ SCHEMA CHANGE: Create a new table with specified columns ~44
⚠️ SCHEMA CHANGE: Create a new table with specified columns
| Name | Type | Req | Description |
|---|---|---|---|
| columns | array | yes | – |
| database | string | – | – |
| name | string | yes | – |
No output schema declared.
No examples provided.
database_info ✓ SAFE: Get information about a database (size, tables, etc.) ~30
✓ SAFE: Get information about a database (size, tables, etc.)
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
describe_table ✓ SAFE: Get schema information for a table ~32
✓ SAFE: Get schema information for a table
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| table | string | yes | – |
No output schema declared.
No examples provided.
drop_table ⚠️ DESTRUCTIVE: Permanently delete a table and all its data ~39
⚠️ DESTRUCTIVE: Permanently delete a table and all its data
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| table | string | yes | – |
No output schema declared.
No examples provided.
execute_read_query ✓ SAFE: Execute read-only SQL queries (SELECT, PRAGMA, EXPLAIN) ~48
✓ SAFE: Execute read-only SQL queries (SELECT, PRAGMA, EXPLAIN)
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| params | object | – | – |
| query | string | yes | – |
No output schema declared.
No examples provided.
execute_schema_query ⚠️ SCHEMA CHANGE: Execute DDL queries (CREATE, ALTER, DROP) ~48
⚠️ SCHEMA CHANGE: Execute DDL queries (CREATE, ALTER, DROP)
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| params | object | – | – |
| query | string | yes | – |
No output schema declared.
No examples provided.
execute_write_query ⚠️ DESTRUCTIVE: Execute SQL that modifies data (INSERT, UPDATE, DELETE) ~49
⚠️ DESTRUCTIVE: Execute SQL that modifies data (INSERT, UPDATE, DELETE)
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| params | object | – | – |
| query | string | yes | – |
No output schema declared.
No examples provided.
export_schema ✓ SAFE: Export database schema as SQL or JSON ~38
✓ SAFE: Export database schema as SQL or JSON
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| format | – | – | – |
| tables | array | – | – |
No output schema declared.
No examples provided.
import_schema ⚠️ SCHEMA CHANGE: Import and execute schema from SQL or JSON ~43
⚠️ SCHEMA CHANGE: Import and execute schema from SQL or JSON
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
| format | – | – | – |
| schema | string | yes | – |
No output schema declared.
No examples provided.
list_databases ✓ SAFE: List available database files in a directory ~27
✓ SAFE: List available database files in a directory
| Name | Type | Req | Description |
|---|---|---|---|
| directory | string | – | – |
No output schema declared.
No examples provided.
list_tables ✓ SAFE: List all tables and views in a database ~27
✓ SAFE: List all tables and views in a database
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
open_database ✓ SAFE: Open or create a SQLite database file ~33
✓ SAFE: Open or create a SQLite database file
| Name | Type | Req | Description |
|---|---|---|---|
| create | boolean | – | – |
| path | string | yes | – |
No output schema declared.
No examples provided.
rollback_transaction ⚠️ TRANSACTION: Rollback the current database transaction ~28
⚠️ TRANSACTION: Rollback the current database transaction
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
vacuum_database ✓ MAINTENANCE: Optimize database storage by reclaiming unused space ~30
✓ MAINTENANCE: Optimize database storage by reclaiming unused space
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | – |
No output schema declared.
No examples provided.
How do I install the io.github.spences10/mcp-sqlite-tools server?
io.github.spences10/mcp-sqlite-tools runs locally as an npm package, launched with npx -y mcp-sqlite-tools. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · mcp-sqlite-tools
claude mcp add spences10-mcp-sqlite-tools -- npx -y mcp-sqlite-tools
What is the io.github.spences10/mcp-sqlite-tools server?
io.github.spences10/mcp-sqlite-tools is listed in the public MCP registry as io.github.spences10/mcp-sqlite-tools. MCP server for local SQLite database operations. This page covers its npm package (mcp-sqlite-tools).
Is the io.github.spences10/mcp-sqlite-tools server safe to use?
io.github.spences10/mcp-sqlite-tools scores 75 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 5 November 2026. It declares no install or post-install scripts. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the io.github.spences10/mcp-sqlite-tools server expose?
io.github.spences10/mcp-sqlite-tools exposes 19 tools: open_database, close_database, list_databases, database_info, list_tables, and 14 more. Their descriptions and schemas cost roughly 676 tokens of context every time the server is loaded.
Is the io.github.spences10/mcp-sqlite-tools server still maintained?
io.github.spences10/mcp-sqlite-tools is still listed as active in the MCP registry. We last reached this channel on 5 November 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the io.github.spences10/mcp-sqlite-tools server under?
io.github.spences10/mcp-sqlite-tools declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.