# io.github.ofershap/sqlite (npm · mcp-sqlite-server)

SQLite MCP — query databases, inspect schemas, explain queries, export data.

- Trust score: 66/100 (medium)
- Change this week: +20
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- npm · `mcp-sqlite-server`: 66/100 (this document), [markdown](https://verifymcp.io/servers/ofershap-sqlite/mcp-sqlite-server.md), [page](https://verifymcp.io/servers/ofershap-sqlite/mcp-sqlite-server)

## Channel facts

- Registry: `npm`
- Package: `mcp-sqlite-server`
- Version: `1.0.1`
- Transport: `stdio`

## Trust breakdown

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. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-03.

- **Supply Chain Security**: 87/100
  - No malware found by supply-chain analysis.
  - Only part of the dependency tree could be resolved (130 of 134), so this covers what we could see, not the whole tree.
  - No install/post-install scripts declared.
  - Only part of the dependency tree could be resolved (130 of 134), so this covers what we could see, not the whole tree.
- **Provenance & Transparency**: 45/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 145 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 77/100
  - AI-judged instruction clarity (excellent).
  - Tool/resource definitions use about 262 tokens (~52/item across 5 items; 5 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**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.

## Install

### Claude

```bash
claude mcp add ofershap-sqlite -- npx -y mcp-sqlite-server
```

### Codex

```bash
codex mcp add ofershap-sqlite -- npx -y mcp-sqlite-server
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "ofershap-sqlite": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "mcp-sqlite-server"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add ofershap-sqlite --command npx --arg -y --arg mcp-sqlite-server
```

### Hermes

```yaml
mcp_servers:
  ofershap-sqlite:
    command: "npx"
    args: ["-y", "mcp-sqlite-server"]
```

### Other

```json
{
  "mcpServers": {
    "ofershap-sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite-server"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-02 (score 66, +45)

- [security regression] Provenance: unverified → fail
- [security improvement] Install scripts: unverified → pass
- [security improvement] Known CVEs: unverified → partial
- [security improvement] Malware scan: unverified → pass
- [security] Stability: Stability not yet verified: not enough scan history yet (needs a 30-day window).
- [functional improvement] Schema quality: unverified → excellent
- [functional improvement] License: unverified → pass
- [functional improvement] Dependency health: unverified → partial
- [functional improvement] Maintenance: unverified → pass
- [functional improvement] MCP protocol: unverified → pass
- [functional] Licence: MIT

### 2026-07-31 (score 21, −7)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-30 (score 28, −18)

- [security regression] Malware scan: pass → unverified

### 2026-07-27 (score 46)

First indexed and scored.

## MCP tools (5)

### `query` (~75 tokens)

Execute a SQL query against a SQLite database. Returns results as a formatted table. Read-only by default.

Input parameters:

- `db` (string, required): Path to the .db or .sqlite file
- `readonly` (boolean): If true, only SELECT/PRAGMA/EXPLAIN allowed
- `sql` (string, required): SQL query to execute

### `schema` (~39 tokens)

Get the schema of a SQLite database: all tables with columns and row counts.

Input parameters:

- `db` (string, required): Path to the .db or .sqlite file

### `table_info` (~51 tokens)

Get detailed info about a single table: columns, types, constraints, and row count.

Input parameters:

- `db` (string, required): Path to the .db or .sqlite file
- `table` (string, required): Table name

### `explain` (~53 tokens)

Explain the query plan for a SQL query (EXPLAIN QUERY PLAN). Helps optimize queries.

Input parameters:

- `db` (string, required): Path to the .db or .sqlite file
- `sql` (string, required): SQL query to explain

### `list_databases` (~44 tokens)

List all SQLite database files (.db, .sqlite, .sqlite3) in a directory.

Input parameters:

- `directory` (string): Directory path to scan (default: current directory)

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/ofershap-sqlite/mcp-sqlite-server#diagnostics

## Score history

- 2026-08-03: 66
- 2026-08-02: 66
- 2026-08-01: 21
- 2026-07-31: 21
- 2026-07-30: 28
- 2026-07-28: 46
- 2026-07-27: 46

## Links

- npm package: https://www.npmjs.com/package/mcp-sqlite-server
- Socket report: https://socket.dev/npm/package/mcp-sqlite-server
- Repository: https://github.com/ofershap/mcp-server-sqlite
- Changelog RSS feed: https://verifymcp.io/servers/ofershap-sqlite/mcp-sqlite-server/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/ofershap-sqlite/mcp-sqlite-server/changelog.json
- HTML version of this page: https://verifymcp.io/servers/ofershap-sqlite/mcp-sqlite-server