Loading connector details…
MCP SQLite Manager
MCPOpen Source20.0
by jonnyhoff • Data & Databases
An MCP server using FastMCP that provides structured tools to query, update, and inspect SQLite databases.
Example Use Cases
- 1
Execute SELECT queries against a local SQLite database and receive results as JSON for downstream processing.
- 2
Perform INSERT, UPDATE, or DELETE operations on a SQLite database programmatically within workflows.
- 3
Inspect and modify database schema: list tables, describe table schema, and create new tables via SQL.
Description
This MCP server exposes SQLite operations (read, write, create table, list tables, describe table) as callable tools for agents. It allows agents to execute SELECT queries and receive JSON results, run INSERT/UPDATE/DELETE operations, and manage schemas via SQL. Designed to be run locally or installed via pipx, it simplifies programmatic interaction with SQLite from agent workflows.
Capabilities(5 total)
Tools (5)
read_query
Execute a SELECT query on the SQLite database. Args: full_db_path: The full path to the SQLite database file. query: The SELECT SQL query to execute. Returns: A list of dictionaries, where each dictionary represents a row.
full_db_path:string*query:string*
write_query
Execute an INSERT, UPDATE, or DELETE query on the SQLite database. Args: full_db_path: The full path to the SQLite database file. query: The SQL query (INSERT, UPDATE, DELETE) to execute. Returns: A success message indicating the number of rows affected.
full_db_path:string*query:string*
create_table
Create a new table in the SQLite database using raw SQL. Args: full_db_path: The full path to the SQLite database file. table_sql: The `CREATE TABLE` SQL statement. Returns: A success message.
full_db_path:string*table_sql:string*
list_tables
List all tables in the SQLite database. Args: full_db_path: The full path to the SQLite database file. Returns: A list of table names.
full_db_path:string*
describe_table
Get the schema information (columns, types, etc.) for a specific table. Args: full_db_path: The full path to the SQLite database file. table_name: The name of the table to describe. Returns: A list of dictionaries, where each dictionary describes a column. Keys include: 'cid', 'name', 'type', 'notnull', 'dflt_value', 'pk'.
full_db_path:string*table_name:string*
Quick Actions
Security
Scanned 2 month(s) agoRisk Level
MODERATE
Can modify files, state, or send data externally
Trust Score
C51/100
5/17 checks passed
Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.
Quick Stats
Service TypeMCP
Pricing ModelFree
Capabilities5 Tools / 0 Prompts / 0 Resources
Ownerjonnyhoff
CategoryData & Databases
DependenciesStandalone
Tags
SQLDatabaseSchemaCRUD