MCP Sqlite

🚀 🐇 MCP SQLite Server

This is a Model Context Protocol (MCP) server that offers comprehensive SQLite database interaction capabilities.

Maintainer

✨ Features

• Complete CRUD operations (Create, Read, Update, Delete).
• Database exploration and introspection.
• Execution of custom SQL queries.

📦 Installation

Define the command in the MCP server settings of your IDE.

For example, in Cursor:

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

Windows users need to use the following:

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

Your database path must be provided as a parameter.

💻 Usage Examples

Available Tools

Database Information

db_info

Get detailed information about the connected database.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "db_info",
    "arguments": {}
  }
}

list_tables

List all tables in the database.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "list_tables",
    "arguments": {}
  }
}

get_table_schema

Get detailed schema information of a table.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "get_table_schema",
    "arguments": {
      "table_name": "users"
    }
  }
}

CRUD Operations

create

Insert new data.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "create",
    "arguments": {
      "table_name": "users",
      "data": {
        "name": "Alice",
        "age": 30
      }
    }
  }
}

read

Read data.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "read",
    "arguments": {
      "table_name": "users",
      "conditions": {
        "age": 25
      }
    }
  }
}

update

Update data.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "update",
    "arguments": {
      "table_name": "users",
      "conditions": {
        "id": 1
      },
      "updates": {
        "age": 31
      }
    }
  }
}

delete

Delete data.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "delete",
    "arguments": {
      "table_name": "users",
      "conditions": {
        "id": 1
      }
    }
  }
}

Custom Queries

query

Execute a custom SQL query on the connected SQLite database.

Example:

{
  "method": "tools/call",
  "params": {
    "name": "query",
    "arguments": {
      "sql": "SELECT * FROM users WHERE id = ?",
      "values": [1]
    }
  }
}

🔧 Technical Details

• Model Context Protocol SDK
• sqlite3

📄 Acknowledgments

If you like this library, please consider supporting my work in the following way 😀

🍵 Buy me a tea here