MCP SQLite Server

MCPOfficialOpen SourceMIT48.4

by jparkerweb • Data & Databases

An MCP server for interacting with SQLite databases through CRUD operations and custom queries.

Example Use Cases

1
Perform CRUD operations on SQLite databases.
2
Explore and inspect SQLite database schemas and tables.
3
Run custom SQL queries for analysis or reporting purposes.

Description

The MCP SQLite Server enables comprehensive interaction with SQLite databases, offering complete CRUD operations, database exploration, and the ability to execute custom SQL queries. It integrates easily with IDEs like Cursor and VSCode, allowing developers to manage and query their SQLite databases directly. This tool is perfect for those needing database introspection and manipulation capabilities within their development environment.

Capabilities(5 total)

Tools (5)

query

Execute a SQL query against a SQLite database. Returns results as a formatted table. Read-only by default.

db:string*sql:string*readonly:boolean

schema

Get the schema of a SQLite database: all tables with columns and row counts.

db:string*

table_info

Get detailed info about a single table: columns, types, constraints, and row count.

db:string*table:string*

explain

Explain the query plan for a SQL query (EXPLAIN QUERY PLAN). Helps optimize queries.

db:string*sql:string*

list_databases

List all SQLite database files (.db, .sqlite, .sqlite3) in a directory.

directory:string

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C55/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

Ownerjparkerweb

CategoryData & Databases

DependenciesStandalone

Set Your Username