================== /// MCP /// /// MCP /// ================== [server:online] [protocol:ready]
mcp-sqlite
by jparkerweb
Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities
23
2
Open Source01
db_info
Get detailed information about the connected database.
02
list_tables
List all tables in the database.
03
get_table_schema
Get detailed information about a table's schema.
04
create_record
Insert a new record into a table.
05
read_records
Query records from a table with optional filtering.
06
update_records
Update records in a table that match specified conditions.
07
delete_records
Delete records from a table that match specified conditions.
08
query
Execute a custom SQL query against the connected SQLite database.
Installation
1. Prerequisites:
• Node.js ≥ 18
• A writable SQLite database file (or the path where one should be created)
2. Add the package to your project:
# with npm
npm install mcp-sqlite --save
# or with yarn
yarn add mcp-sqlite
3. (Optional) Create a .env file to point the server at a specific database:
MCP_SQLITE_DB_PATH=./database.sqlite
4. Start the MCP server from the command line:
npx mcp-sqlite --port 3333 # default port 3333
5. Integrate with your MCP router / orchestrator by registering the server URL (e.g. http://localhost:3333) so that the tools declared below become available to your models.
Documentation
License: MIT License
Updated 7/15/2025