🐇 MCP SQLite Server

Name: 🐇 MCP SQLite Server
Author: jparkerweb

@jparkerweb

リポジトリホームページ

🐇 MCP SQLite Server について

🐇 Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities

#nodejs #development #database #sqlite #mcp #cursor #windsurf #aitooling

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

jparkerweb

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "MCP SQLite Server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite",
        "<path-to-your-sqlite-database.db>"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is 🐇 MCP SQLite Server?

The 🐇 MCP SQLite Server is a Model Context Protocol (MCP) server that provides comprehensive SQLite database interaction capabilities. It is designed for developers using MCP-compatible IDEs (e.g., Cursor, VSCode) who need to perform CRUD operations, explore schemas, and execute custom SQL queries against a local SQLite database.

How to use 🐇 MCP SQLite Server?

Define the command in your IDE’s MCP Server settings using npx -y mcp-sqlite <path-to-your-sqlite-database.db>. For example, in Cursor add a JSON entry under mcpServers; in VSCode use "servers" with type "stdio". The database path must be provided as a command argument.

Key features of 🐇 MCP SQLite Server

Complete CRUD operations (Create, Read, Update, Delete)
Database exploration and schema introspection
Execute custom parameterized SQL queries
Retrieve database metadata with db_info
List all tables with list_tables
Get detailed table schema with get_table_schema

Use cases of 🐇 MCP SQLite Server

Exploring the structure and schema of a SQLite database
Inserting, reading, updating, or deleting records with optional filtering
Running ad‑hoc SQL queries with parameter binding
Inspecting database metadata and table lists directly from an MCP client

FAQ from 🐇 MCP SQLite Server

What is the 🐇 MCP SQLite Server?

It is an MCP server that provides SQLite database interaction capabilities, enabling CRUD operations, schema exploration, and custom SQL execution within MCP‑compatible clients.

How do I install and configure it?

Install and run it via npx -y mcp-sqlite <path-to-your-sqlite-database.db>. Configure the command in your IDE’s MCP Server settings (e.g., Cursor or VSCode).

What tools are available?

The server exposes tools for database info (db_info), listing tables (list_tables), schema retrieval (get_table_schema), CRUD operations (create_record, read_records, update_records, delete_records), and custom queries (query).

What dependencies does it require?

It is built with the Model Context Protocol SDK and the node-sqlite3 library.

Where does the database data live?

The data resides in a SQLite database file whose path you provide as an argument when launching the server.

「データベース」の他のコンテンツ

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

mcp_mysql_server

wenb1n-dev

245

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412