Command Palette

Search for a command to run...

UnylyUnyly
Browse all

Sqlite3

FreeNot checked

Exposes sqlite3 database functionality as MCP tools, enabling SQL query execution, schema management, and CRUD operations.

daedalusby daedalus
GitHubEmbed

About

Exposes sqlite3 database functionality as MCP tools, enabling SQL query execution, schema management, and CRUD operations.

README

MCP server exposing sqlite3 library functionality

PyPI Python Ruff

Install

pip install mcp-sqlite3

Usage

from mcp_sqlite3 import mcp_server

mcp_server.run()

CLI

mcp-sqlite3 --help

API

Exposes complete sqlite3 functionality as MCP tools.

Connection Tools

  • connect_database - Open a database connection
  • close_connection - Close a database connection
  • commit / rollback - Transaction control

SQL Execution Tools

  • execute_query - Execute a query and return results
  • execute_many - Execute with multiple parameter sets
  • execute_script - Execute a SQL script

Schema Tools

  • list_tables - List all tables
  • get_table_info - Get table schema
  • create_table / drop_table - DDL operations

CRUD Tools

  • insert_row / update_rows / delete_rows / select_rows

Development

git clone https://github.com/daedalus/mcp-sqlite3.git
cd mcp-sqlite3
pip install -e ".[test]"

# run tests
pytest

# format
ruff format src/ tests/

# lint
ruff check src/ tests/

# type check
mypy src/

MCP Server

mcp-name: io.github.daedalus/mcp-sqlite3

from github.com/daedalus/mcp-sqlite3

Installing Sqlite3

This server has no published package — it is built from source. Open the repository and follow its README.

▸ github.com/daedalus/mcp-sqlite3

FAQ

Is Sqlite3 MCP free?

Yes, Sqlite3 MCP is free — one-click install via Unyly at no cost.

Does Sqlite3 need an API key?

No, Sqlite3 runs without API keys or environment variables.

Is Sqlite3 hosted or self-hosted?

Self-hosted: the server runs locally on your machine via the install command above.

How do I install Sqlite3 in Claude Desktop, Claude Code or Cursor?

Open Sqlite3 on unyly.org, pick your client tab (Claude Desktop, Claude Code, Cursor) and press Install — the config is generated automatically, no JSON editing.

Related MCPs

Postgres

Query your database in natural language

Anthropicby Anthropic

wenb1n-dev/SmartDB_MCP

Connect to multiple databases at once (MySQL, PostgreSQL, SQL Server, MariaDB, Dameng, Oracle) for operations, health analysis and SQL optimization.

wenb1n-devby wenb1n-dev

Postgres Server

This server enables interaction with PostgreSQL databases through the Model Context Protocol, optimized for the AWS Bedrock AgentCore Runtime. It provides tools

madhurprashby madhurprash

PostgreSQL

Read-only database access with schema inspection.

modelcontextprotocolby modelcontextprotocol

Redis

Interact with Redis key-value stores.

modelcontextprotocolby modelcontextprotocol

SQLite

Database interaction and business intelligence capabilities.

modelcontextprotocolby modelcontextprotocol

mxcp

Open-source framework for building enterprise-grade MCP servers using just YAML, SQL, and Python, with built-in auth, monitoring, ETL and policy enforcement.

raw-labsby raw-labs

julien040/anyquery

Query apps with SQL from a single local-first binary; also connects to PostgreSQL, MySQL and SQLite-compatible databases.

julien040by julien040

drakonkat/wizzy-mcp-tmdb

Search and retrieve movie, TV show and person information from The Movie Database (TMDB) API.

drakonkatby drakonkat

longevity-genie/opengenes-mcp

Query the OpenGenes database for aging and longevity research.

longevity-genieby longevity-genie

Compare Sqlite3 with

Sqlite3vsPostgresSqlite3vswenb1n-dev/SmartDB_MCPSqlite3vsPostgres ServerSqlite3vsPostgreSQLSqlite3vsRedisSqlite3vsSQLiteSqlite3vsmxcpSqlite3vsjulien040/anyquerySqlite3vsdrakonkat/wizzy-mcp-tmdbSqlite3vslongevity-genie/opengenes-mcp

Not sure what to pick?

Find your stack in 60 seconds

Author?

Embed badge for your README

Browse similar

All data MCPs