SQLite (Archived) MCP Server
Database interaction and business intelligence capabilities.
What is an MCP Server?
MCP Info
Image Building Info
Available Tools (6)
| Tools provided by this Server |
Short Description |
append_insight |
Add a business insight to the memo |
create_table |
Create a new table in the SQLite database |
describe_table |
Get the schema information for a specific table |
list_tables |
List all tables in the SQLite database |
read_query |
Execute a SELECT query on the SQLite database |
write_query |
Execute an INSERT, UPDATE, or DELETE query on the SQLite database |
Tools Details
Add a business insight to the memo
| Parameters |
Type |
Description |
insight |
string |
Business insight discovered from data analysis |
Create a new table in the SQLite database
| Parameters |
Type |
Description |
query |
string |
CREATE TABLE SQL statement |
Get the schema information for a specific table
| Parameters |
Type |
Description |
table_name |
string |
Name of the table to describe |
List all tables in the SQLite database
Execute a SELECT query on the SQLite database
| Parameters |
Type |
Description |
query |
string |
SELECT SQL query to execute |
Execute an INSERT, UPDATE, or DELETE query on the SQLite database
| Parameters |
Type |
Description |
query |
string |
SQL query to execute |
Use this MCP Server
{
"mcpServers": {
"SQLite": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-v",
"/local-directory:/local-directory",
"mcp/sqlite",
"--db-path",
"/mcp/db.sqlite"
]
}
}
}
Why is it safer to run MCP Servers with Docker?