# io.github.spences10/mcp-sqlite-tools (npm · mcp-sqlite-tools)

MCP server for local SQLite database operations

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

## Components

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

## Channel facts

- Registry: `npm`
- Package: `mcp-sqlite-tools`
- Version: `0.0.11`
- 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**: 38/100
  - Malware scan not yet available for this package.
  - No known CVEs affecting this package version or its production dependencies.
  - No install/post-install scripts declared.
  - 48 of 49 dependencies flagged as unhealthy (47 deprecated).
- **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 90 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 43/100
  - AI-judged instruction clarity (poor).
  - Tool/resource definitions use about 676 tokens (~35/item across 19 items; 19 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**: 67/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 0% of tool parameters carry a description.
- **Capabilities**: 60/100
  - Spec-recency check failed: implements MCP spec 2025-06-18; 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 spences10-mcp-sqlite-tools -- npx -y mcp-sqlite-tools
```

### Codex

```bash
codex mcp add spences10-mcp-sqlite-tools -- npx -y mcp-sqlite-tools
```

### opencode

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

### OpenClaw

```bash
openclaw mcp add spences10-mcp-sqlite-tools --command npx --arg -y --arg mcp-sqlite-tools
```

### Hermes

```yaml
mcp_servers:
  spences10-mcp-sqlite-tools:
    command: "npx"
    args: ["-y", "mcp-sqlite-tools"]
```

### Other

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

## 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 39, 0)

- [functional regression] Dependency health: 0.78 → 0.08
- [functional improvement] Schema quality: unverified → poor

### 2026-08-01 (score 39, +21)

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

### 2026-07-31 (score 18, −6)

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

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

First indexed and scored.

## MCP tools (19)

### `open_database` (~33 tokens)

✓ SAFE: Open or create a SQLite database file

✓ SAFE: Open or create a SQLite database file

Input parameters:

- `create` (boolean)
- `path` (string, required)

### `close_database` (~23 tokens)

✓ SAFE: Close a database connection

✓ SAFE: Close a database connection

Input parameters:

- `database` (string)

### `list_databases` (~27 tokens)

✓ SAFE: List available database files in a directory

✓ SAFE: List available database files in a directory

Input parameters:

- `directory` (string)

### `database_info` (~30 tokens)

✓ SAFE: Get information about a database (size, tables, etc.)

✓ SAFE: Get information about a database (size, tables, etc.)

Input parameters:

- `database` (string)

### `list_tables` (~27 tokens)

✓ SAFE: List all tables and views in a database

✓ SAFE: List all tables and views in a database

Input parameters:

- `database` (string)

### `describe_table` (~32 tokens)

✓ SAFE: Get schema information for a table

✓ SAFE: Get schema information for a table

Input parameters:

- `database` (string)
- `table` (string, required)

### `create_table` (~44 tokens)

⚠️ SCHEMA CHANGE: Create a new table with specified columns

⚠️ SCHEMA CHANGE: Create a new table with specified columns

Input parameters:

- `columns` (array, required)
- `database` (string)
- `name` (string, required)

### `drop_table` (~39 tokens)

⚠️ DESTRUCTIVE: Permanently delete a table and all its data

⚠️ DESTRUCTIVE: Permanently delete a table and all its data

Input parameters:

- `database` (string)
- `table` (string, required)

### `backup_database` (~35 tokens)

✓ SAFE: Create a backup copy of a database

✓ SAFE: Create a backup copy of a database

Input parameters:

- `backup_path` (string)
- `source_database` (string)

### `vacuum_database` (~30 tokens)

✓ MAINTENANCE: Optimize database storage by reclaiming unused space

✓ MAINTENANCE: Optimize database storage by reclaiming unused space

Input parameters:

- `database` (string)

### `execute_read_query` (~48 tokens)

✓ SAFE: Execute read-only SQL queries (SELECT, PRAGMA, EXPLAIN)

✓ SAFE: Execute read-only SQL queries (SELECT, PRAGMA, EXPLAIN)

Input parameters:

- `database` (string)
- `params` (object)
- `query` (string, required)

### `execute_write_query` (~49 tokens)

⚠️ DESTRUCTIVE: Execute SQL that modifies data (INSERT, UPDATE, DELETE)

⚠️ DESTRUCTIVE: Execute SQL that modifies data (INSERT, UPDATE, DELETE)

Input parameters:

- `database` (string)
- `params` (object)
- `query` (string, required)

### `execute_schema_query` (~48 tokens)

⚠️ SCHEMA CHANGE: Execute DDL queries (CREATE, ALTER, DROP)

⚠️ SCHEMA CHANGE: Execute DDL queries (CREATE, ALTER, DROP)

Input parameters:

- `database` (string)
- `params` (object)
- `query` (string, required)

### `bulk_insert` (~51 tokens)

⚠️ DESTRUCTIVE: Insert multiple records efficiently in batches

⚠️ DESTRUCTIVE: Insert multiple records efficiently in batches

Input parameters:

- `batch_size` (number)
- `data` (array, required)
- `database` (string)
- `table` (string, required)

### `begin_transaction` (~26 tokens)

⚠️ TRANSACTION: Begin a database transaction

⚠️ TRANSACTION: Begin a database transaction

Input parameters:

- `database` (string)

### `commit_transaction` (~25 tokens)

✓ TRANSACTION: Commit the current database transaction

✓ TRANSACTION: Commit the current database transaction

Input parameters:

- `database` (string)

### `rollback_transaction` (~28 tokens)

⚠️ TRANSACTION: Rollback the current database transaction

⚠️ TRANSACTION: Rollback the current database transaction

Input parameters:

- `database` (string)

### `export_schema` (~38 tokens)

✓ SAFE: Export database schema as SQL or JSON

✓ SAFE: Export database schema as SQL or JSON

Input parameters:

- `database` (string)
- `format`
- `tables` (array)

### `import_schema` (~43 tokens)

⚠️ SCHEMA CHANGE: Import and execute schema from SQL or JSON

⚠️ SCHEMA CHANGE: Import and execute schema from SQL or JSON

Input parameters:

- `database` (string)
- `format`
- `schema` (string, required)

## Diagnostics

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

## Score history

- 2026-08-03: 39
- 2026-08-02: 39
- 2026-08-01: 39
- 2026-07-31: 18
- 2026-07-30: 24
- 2026-07-28: 24
- 2026-07-27: 24

## Links

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