Mcp Sqlite Tools
Local SQLite integration that gives Claude direct database access through stdio. Exposes read operations like SELECT queries, schema inspection, and table listing alongside write operations for INSERT, UPDATE, and DELETE. Built with safety in mind: tools are intentionally separated so you can auto-approve reads while requiring confirmation for destructive writes and schema changes. Includes transaction support with savepoints, bulk insert for batch operations, and maintenance tools like vacuum and backup. Works well with the global npx setup so databases live wherever your current workspace is. Reach for this when you want Claude to query local data, generate reports from SQLite files, or help build database schemas interactively.
- GitHub stars
- 19
- tools
- 22
- transport
- STDIO
- last updated
- Sep 10, 2025
Tools
22 toolsPublic tool metadata for what this MCP can expose to an agent.
open_databaseOpen an existing database
Open an existing database
No parameter schema in public metadata yet.
close_databaseClose one database connection
Close one database connection
No parameter schema in public metadata yet.
list_databasesFind database files in a directory
Find database files in a directory
No parameter schema in public metadata yet.
database_infoRead file and SQLite metadata
Read file and SQLite metadata
No parameter schema in public metadata yet.
list_tablesList tables and views
List tables and views
No parameter schema in public metadata yet.
describe_tableRead columns and constraints
Read columns and constraints
No parameter schema in public metadata yet.
backup_databaseCreate a consistent online backup
Create a consistent online backup
No parameter schema in public metadata yet.
export_csvExport a table or read-only query
Export a table or read-only query
No parameter schema in public metadata yet.
export_schemaExport schema as SQL or JSON
Export schema as SQL or JSON
No parameter schema in public metadata yet.
execute_read_queryRun one SQLite read-only statement
Run one SQLite read-only statement
No parameter schema in public metadata yet.
create_databaseCreate a new database file
Create a new database file
No parameter schema in public metadata yet.
create_tableCreate a table from validated columns
Create a table from validated columns
No parameter schema in public metadata yet.
drop_tableDrop a table and its data
Drop a table and its data
No parameter schema in public metadata yet.
execute_write_queryRun INSERT, UPDATE, or DELETE
Run INSERT, UPDATE, or DELETE
No parameter schema in public metadata yet.
execute_schema_queryRun one schema statement
Run one schema statement
No parameter schema in public metadata yet.
bulk_insertInsert records in batches
Insert records in batches
No parameter schema in public metadata yet.
import_csvImport a headered CSV file
Import a headered CSV file
No parameter schema in public metadata yet.
import_schemaApply SQL or JSON schema objects
Apply SQL or JSON schema objects
No parameter schema in public metadata yet.
vacuum_databaseRebuild a database to reclaim space
Rebuild a database to reclaim space
No parameter schema in public metadata yet.
begin_transactionBegin a transaction or nested savepoint
Begin a transaction or nested savepoint
No parameter schema in public metadata yet.
commit_transactionCommit or release a savepoint
Commit or release a savepoint
No parameter schema in public metadata yet.
rollback_transactionRoll back a transaction or savepoint
Roll back a transaction or savepoint
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
mcp-sqlite-tools
A Model Context Protocol (MCP) server for safe, local SQLite database operations. It gives MCP clients explicit read, write, schema, transaction, CSV, backup, and maintenance tools.
Features
- Open, create, inspect, back up, vacuum, and close SQLite databases
- List, describe, create, and drop tables
- Run paginated read queries with named or positional parameters
- Run explicit write and schema queries
- Import and export headered CSV files
- Use transactions with nested savepoints
- Export and import schemas as SQL or JSON
- Restrict database and CSV paths through configuration
- Classify destructive tools for client approval policies
- Use Node's built-in SQLite driver with no native addon dependency
Requirements
- Node.js 24.12 or later
- An MCP client with stdio server support
Configure your MCP client
The MCP client starts this server through npx; a global installation
is not required.
Install with MCPick
MCPick can add the server to a supported client without manual JSON editing. This command targets Claude Code's local scope by default:
Details
- Repository
- github.com/spences10/mcp-sqlite-tools
- Category
- Databases
- Package
mcp-sqlite-tools- Transport
- STDIO
- Registry
- MCP registry, active
More from spences10
Related Databases MCP servers
View all
PostgreSQL MCP Serverneverinfamous/postgres-mcpEnterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations8stars
Read Only Local Mysql Mcp Serverhovecapital/read-only-local-mysql-mcp-serverMCP server for read-only MySQL database queries in Claude Desktop6stars
Afgong Sqlite Mcp Serverafgong/sqlite-mcp-serverExplore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…0stars
Mongo Scout Mcpbluwork/mongo-scout-mcpScout your MongoDB databases with AI - safety features, live monitoring, and data quality0stars
MySQL MCP Servermusaddiq-dev/mysql-mcp-serverPython MCP server for MySQL database inspection and querying0stars
Supabase Rls Checktthanh2k6/supabase-rls-checkRead-only Supabase RLS checks: explain rules, analyze/diff SQL exports, scan public env vars.0stars