sqlite-mcp-server

enesmanan/sqlite-mcp-server

3.3

If you are the rightful owner of sqlite-mcp-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 dayong@mcphub.com.

A general-purpose Model Context Protocol (MCP) server for SQLite databases, providing read and write access through Claude Desktop and other MCP clients.

Tools

Functions exposed to the LLM to take actions

list_databases

List all available .db files in the database folder.

list_tables

List all tables in a specific database.

describe_table

Get detailed table structure (columns, types, constraints).

query_database

Execute SELECT queries with automatic LIMIT protection.

insert_data

Insert new rows into tables.

update_data

Update existing rows (requires WHERE clause).

delete_data

Delete rows (requires WHERE clause).

execute_raw_sql

Execute any SQL query (use with caution).

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources