Raja SQL MCP

An MCP (Model Context Protocol) server for interacting with SQLite databases. This server provides tools to inspect database schemas, execute SQL queries, and perform CRUD operations, making it easy to integrate databases with AI agents and LLM-powered applications.

---

Features

✅ Execute SQL queries

✅ List all tables in the database

✅ Inspect table schemas

✅ Execute SELECT queries

✅ Insert data dynamically

✅ Update existing records

✅ Delete records safely

✅ SQLite-based (no external database server required)

---

Installation

pip install raja-sql-mcp

---

Running the Server

sql-mcp

Or during development:

uv run python -m src.sql_mcp.main

---

MCP Inspector Configuration

Transport

STDIO

Command

uv

Arguments

run python -m src.sql_mcp.main

Working Directory

/path/to/SQL_MCP

---

Available Tools

list_tables()

Returns all tables in the database.

Example:

list_tables()

---

describe_table(table_name)

Returns the schema of the specified table.

Example:

describe_table("users")

---

execute_sql(query)

Executes SQL queries such as:

• CREATE TABLE
• INSERT
• UPDATE
• DELETE
• DROP TABLE
• ALTER TABLE

Example:

execute_sql("""
CREATE TABLE users(
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER
)
""")

---

execute_select(query)

Executes SELECT queries and returns rows.

Example:

execute_select(
    "SELECT * FROM users"
)

---

insert_data(table_name, data)

Insert records dynamically.

Example:

insert_data(
    "users",
    {
        "name": "Raja",
        "age": 21
    }
)

---

update_data(table_name, data, condition)

Update existing records.

Example:

update_data(
    "users",
    {
        "age": 22
    },
    "id = 1"
)

---

delete_data(table_name, condition)

Delete records matching a condition.

Example:

delete_data(
    "users",
    "id = 1"
)

---

Example Workflow

Create a table:

execute_sql("""
CREATE TABLE users(
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER
)
""")

Insert data:

insert_data(
    "users",
    {
        "name": "Raja",
        "age": 20
    }
)

Query data:

execute_select(
    "SELECT * FROM users"
)

Update data:

update_data(
    "users",
    {
        "age": 21
    },
    "id = 1"
)

Delete data:

delete_data(
    "users",
    "id = 1"
)

---

Project Structure

SQL_MCP/
│
├── src/
│   └── sql_mcp/
│       ├── __init__.py
│       ├── database.py
│       ├── tools.py
│       └── main.py
│
├── README.md
├── LICENSE
├── pyproject.toml
└── uv.lock

---

Use Cases

• AI Database Agents
• Cursor-like Coding Assistants
• LLM-powered CRUD Applications
• Database Automation
• Schema Inspection Tools
• SQL Learning and Experimentation

---

License

MIT License © 2026 Anna Vamsi Krishna Raja