liliang-cn/mcp-sqlite-server
If you are the rightful owner of mcp-sqlite-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCP SQLite Server is a Go-based server that facilitates secure interactions with SQLite databases through a Model Context Protocol interface.
Tools
Functions exposed to the LLM to take actions
create_database
Create new SQLite database files
switch_database
Switch to different database
current_database
Show current database path
list_database_files
List all databases in directory
database_exists
Check if database file exists
delete_database
Delete database file (with confirmation)
list_tables
List all tables
describe_table
Get table schema
create_table
Create new tables
drop_table
Delete tables
query
Execute SELECT queries
execute
Execute INSERT/UPDATE/DELETE statements
transaction
Execute multiple statements atomically
create_index
Create indexes with advanced options
list_indexes
List table indexes
drop_index
Remove indexes
vacuum
Optimize database
analyze_query
Analyze query execution plans
database_stats
Get database statistics
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client