MCP Sqlite
未认领🐇 Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities
工具（16 个）
conditions
(object, optional): Filter conditions as key-value pairs
create_record
Insert a new record into a table.
data
(object): Record data as key-value pairs
db_info
Get detailed information about the connected database.
delete_records
Delete records from a table that match specified conditions.
get_table_schema
Get detailed information about a table's schema.
limit
(number, optional): Maximum number of records to return
list_tables
List all tables in the database.
offset
(number, optional): Number of records to skip
query
Execute a custom SQL query against the connected SQLite database.
read_records
Query records from a table with optional filtering.
sql
(string): The SQL query to execute
table
(string): Name of the table
tableName
(string): Name of the table
update_records
Update records in a table that match specified conditions.
values
(array, optional): Array of parameter values to use in the query