do-nothing.ai

SQLite MCP

open sourcestdio

Full read and write access to a local SQLite database with schema inspection

Updated 2026-02-15

DatabaseFree· Open source, self-hosted. SQLite database stored as a local file.GitHubDocs

Official MCP server for SQLite databases. Unlike the Postgres MCP (read-only), this server supports full read and write operations, agents can create tables, insert rows, run queries, and inspect schema. Ideal for agents that need lightweight persistent storage without an external database.

Install

uvx mcp-server-sqlite --db-path /path/to/db.sqlite

Runtime: python

Tools (6)

read_query

Execute a SELECT query on the SQLite database

query
write_query

Execute an INSERT, UPDATE, or DELETE query on the SQLite database

query
create_table

Create a new table in the SQLite database

query
list_tables

List all tables in the SQLite database

describe_table

Get the schema information for a specific table

table_name
append_insight

Add a business insight to the memo resource

insight

Use Cases

  • ·Give agents a lightweight persistent data store without external dependencies
  • ·Enable agents to track state, records, and history across sessions
  • ·Build agents that log events, store results, or maintain queues
  • ·Local analytics and reporting with full SQL access

Key Points

  • •Full read and write SQL access, unlike Postgres MCP which is read-only
  • •No external database required, stores data in a local .sqlite file
  • •Python-based, install with uvx or pip
  • •Official Anthropic-maintained server

Do-Nothing Score

Find out how close you are to Ghost CEO.

Take the quiz

Machine-Readable

This MCP is available as structured JSON via the API.

GET /api/v1/mcps/sqlite