jparkerweb/mcp-sqlite

This is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities.
Maintained by
Features
- Complete CRUD operations (Create, Read, Update, Delete)
- Database exploration and introspection
- Execute custom SQL queries
Setup
Define the command in your IDE's MCP Server settings:
e.g. Cursor:
e.g. VSCode:
Your database path must be provided as an argument.
Available Tools
Database Information
db_info
Get detailed information about the connected database.
Example:
list_tables
List all tables in the database.
Example:
get_table_schema
Get detailed information about a table's schema.
Parameters:
- tableName (string): Name of the table
Example:
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:
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:
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:
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:
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:
Built with
- Model Context Protocol SDK
- sqlite3
---
Appreciation
If you enjoy this library please consider sending me a tip to support my work 😀