🐇 MCP SQLite Server
About
🐇 Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities
Details
- Author
- jparkerweb
- GitHub stars
- 114
- Downloads
- 508
- Categories
- Database, Developer Tools
Jump to
- Complete CRUD operations (Create, Read, Update, Delete)
- Database exploration and schema introspection
- Execute custom parameterized SQL queries
- Retrieve database metadata with db_info
- List all tables with list_tables
- Get detailed table schema with get_table_schema
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
🐇 MCP SQLite ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Define the command in your IDE’s MCP Server settings using npx -y mcp-sqlite <path-to-your-sqlite-database.db>. For example, in Cursor add a JSON entry under mcpServers; in VSCode use "servers" with type "stdio". The database path must be provided as a command argument.
db_info
Get information about the SQLite database including path, existence, size, and table count
query
Execute a raw SQL query against the database with optional parameter values
list_tables
List all user tables in the SQLite database (excludes system tables)
get_table_schema
Get the schema information for a specific table including column details
create_record
Insert a new record into a table with specified data
read_records
Read records from a table with optional conditions, limit, and offset
update_records
Update records in a table based on specified conditions
delete_records
Delete records from a table based on specified conditions
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"\ud83d\udc07 mcp sqlite server": {
"MCP SQLite Server": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}
}
}McpServers
{
"MCP SQLite Server": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}🐇 MCP SQLite Server
This is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities.
Maintained by
<a href="https://www.equilllabs.com">
</a>
Features
- Complete CRUD operations (Create, Read, Update, Delete) - Database exploration and introspection - Execute custom SQL queriesSetup
Define the command in your IDE's MCP Server settings: e.g.Cursor:
``json
{
"mcpServers": {
"MCP SQLite Server": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}
}
`
e.g. VSCode:
`json
{
"servers": {
"MCP SQLite Server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}
}
`
Your database path must be provided as an argument.
Available Tools
Database Information
db_info
Get detailed information about the connected database.
Example:
`json
{
"method": "tools/call",
"params": {
"name": "db_info",
"arguments": {}
}
}
`
list_tables
List all tables in the database.
Example:
`json
{
"method": "tools/call",
"params": {
"name": "list_tables",
"arguments": {}
}
}
`
get_table_schema
Get detailed information about a table's schema.
Parameters:
- tableName (string): Name of the table
Example:
`json
{
"method": "tools/call",
"params": {
"name": "get_table_schema",
"arguments": {
"tableName": "users"
}
}
}
`
CRUD Operations
create_record
Insert a new record into a table.
Parameters:
- table (string): Name of the table
- data (object): Record data as key-value pairs
Example:
`json
{
"method": "tools/call",
"params": {
"name": "create_record",
"arguments": {
"table": "users",
"data": {
"name": "John Doe",
"email": "john@example.com",
"age": 30
}
}
}
}
`
read_records
Query records from a table with optional filtering.
Parameters:
- table (string): Name of the table
- conditions (object, optional): Filter conditions as key-value pairs
- limit (number, optional): Maximum number of records to return
- offset (number, optional): Number of records to skip
Example:
`json
{
"method": "tools/call",
"params": {
"name": "read_records",
"arguments": {
"table": "users",
"conditions": {
"age": 30
},
"limit": 10,
"offset": 0
}
}
}
`
update_records
Update records in a table that match specified conditions.
Parameters:
- table (string): Name of the table
- data (object): New values as key-value pairs
- conditions (object): Filter conditions as key-value pairs
Example:
`json
{
"method": "tools/call",
"params": {
"name": "update_records",
"arguments": {
"table": "users",
"data": {
"email": "john.updated@example.com"
},
"conditions": {
"id": 1
}
}
}
}
`
delete_records
Delete records from a table that match specified conditions.
Parameters:
- table (string): Name of the table
- conditions (object): Filter conditions as key-value pairs
Example:
`json
{
"method": "tools/call",
"params": {
"name": "delete_records",
"arguments": {
"table": "users",
"conditions": {
"id": 1
}
}
}
}
`
Custom Queries
query
Execute a custom SQL query against the connected SQLite database.
Parameters:
- sql (string): The SQL query to execute
- values (array, optional): Array of parameter values to use in the query
Example:
`json
{
"method": "tools/call",
"params": {
"name": "query",
"arguments": {
"sql": "SELECT * FROM users WHERE id = ?",
"values": [1]
}
}
}
``
Built with
- Model Context Protocol SDK - sqlite3 ---Appreciation
If you enjoy this library please consider sending me a tip to support my work 😀🍵 tip me here
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
