io.github.ofershap/sqlite
NPM · MCP-SQLITE-SERVER · SCANNED AUG 3
SQLite MCP — query databases, inspect schemas, explain queries, export data.
Available components
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 →
Supply Chain Security87
- No malware found by supply-chain analysis.Pass
- Only part of the dependency tree could be resolved (130 of 134), so this covers what we could see, not the whole tree.Partial
- No install/post-install scripts declared.Pass
- Only part of the dependency tree could be resolved (130 of 134), so this covers what we could see, not the whole tree. 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 145 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability77
- AI-judged instruction clarity (excellent).Pass
- Tool/resource definitions use about 262 tokens (~52/item across 5 items; 5 tools + 0 resources), lean.Pass
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management0
- Stability not yet verified: not enough scan history yet (needs a 30-day window).Unverified
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
Unverified: 1 category
A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.
Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.
npm · mcp-sqlite-server
claude mcp add ofershap-sqlite -- npx -y mcp-sqlite-server
codex mcp add ofershap-sqlite -- npx -y mcp-sqlite-server
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"ofershap-sqlite": {
"type": "local",
"command": [
"npx",
"-y",
"mcp-sqlite-server"
],
"enabled": true
}
}
} openclaw mcp add ofershap-sqlite --command npx --arg -y --arg mcp-sqlite-server
mcp_servers:
ofershap-sqlite:
command: "npx"
args: ["-y", "mcp-sqlite-server"] {
"mcpServers": {
"ofershap-sqlite": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite-server"
]
}
}
} 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.
- 2 Aug 26 +45
- Provenance: unverified → fail ▼ security
- Install scripts: unverified → pass ▲ security
- Known CVEs: unverified → partial ▲ security
- Malware scan: unverified → pass ▲ security
- Stability: Stability not yet verified: not enough scan history yet (needs a 30-day window). security
- Schema quality: unverified → excellent ▲ functional
- License: unverified → pass ▲ functional
- Dependency health: unverified → partial ▲ functional
- Maintenance: unverified → pass ▲ functional
- MCP protocol: unverified → pass ▲ functional
- Licence: MIT functional
- 31 Jul 26 −7
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 30 Jul 26 −18
- Malware scan: pass → unverified ▼ security
- 27 Jul 26 46
First indexed and scored.
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 3 Aug 2026 · Analysed npm/[email protected]
Provenance none
Ecosystem: npm · Outcome: none
Dependencies 130 packages
130 packages in the resolved dependency tree · 130 deprecated · 49 stale.
The dependency tree was only partially resolved, so these counts may be incomplete.
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.
explain ~53
Explain the query plan for a SQL query (EXPLAIN QUERY PLAN). Helps optimize queries.
| Name | Type | Req | Description |
|---|---|---|---|
| db | string | yes | Path to the .db or .sqlite file |
| sql | string | yes | SQL query to explain |
No output schema declared.
No examples provided.
list_databases ~44
List all SQLite database files (.db, .sqlite, .sqlite3) in a directory.
| Name | Type | Req | Description |
|---|---|---|---|
| directory | string | — | Directory path to scan (default: current directory) |
No output schema declared.
No examples provided.
query ~75
Execute a SQL query against a SQLite database. Returns results as a formatted table. Read-only by default.
| Name | Type | Req | Description |
|---|---|---|---|
| db | string | yes | Path to the .db or .sqlite file |
| readonly | boolean | — | If true, only SELECT/PRAGMA/EXPLAIN allowed |
| sql | string | yes | SQL query to execute |
No output schema declared.
No examples provided.
schema ~39
Get the schema of a SQLite database: all tables with columns and row counts.
| Name | Type | Req | Description |
|---|---|---|---|
| db | string | yes | Path to the .db or .sqlite file |
No output schema declared.
No examples provided.
table_info ~51
Get detailed info about a single table: columns, types, constraints, and row count.
| Name | Type | Req | Description |
|---|---|---|---|
| db | string | yes | Path to the .db or .sqlite file |
| table | string | yes | Table name |
No output schema declared.
No examples provided.