Loading...
{
"mcpServers": {
"MCP SQLite Server": {
"command": "npx",
"args": [
"-y",
"mcp-sqlite",
"<path-to-your-sqlite-database.db>"
]
}
}
}db_infoRetrieves detailed information about the connected SQLite database.
Read-only operation with no side effects.
list_tablesLists all tables present within the connected SQLite database.
Read-only operation; only lists table names.
get_table_schemaProvides the schema information for a specified table.
Read-only operation; retrieves table structure.
create_recordInserts a new record into a specified table.
Modifies data by adding new records.
read_recordsQueries records from a table, optionally filtered by conditions.
Read-only operation; retrieves data based on conditions.
update_recordsUpdates records in a table that match specified conditions.
Modifies existing data based on conditions.
delete_recordsDeletes records from a table that match specified conditions.
Destructive operation; removes data from the database.
queryExecutes a custom SQL query against the connected SQLite database.
Allows arbitrary SQL execution, posing a high risk of SQL injection and data breaches.
This server is relatively safe for read-only operations and basic CRUD if the database is properly secured. However, the 'query' tool and lack of authentication make it risky when handling untrusted inputs or operating in sensitive environments. Always sanitize inputs and limit database access privileges.