Raja SQL MCP
The Raja SQL MCP server provides an MCP-compatible interface to interact with SQLite databases, enabling AI agents and LLM-powered applications to perform full database operations — no external database server required.
Execute SQL (
execute_sql): Run any SQL statement includingCREATE TABLE,INSERT,UPDATE,DELETE,DROP TABLE, andALTER TABLE.List Tables (
list_tables): Retrieve all tables in the database.Describe Table Schema (
describe_table): Inspect the schema/structure of a specific table.Execute SELECT Queries (
execute_select): RunSELECTqueries and retrieve resulting rows.Insert Data (
insert_data): Add new records into a table using a column-value data object.Update Data (
update_data): Modify existing records in a table based on a specified condition.Delete Data (
delete_data): Remove records from a table matching a given condition.
Provides tools to interact with SQLite databases, including executing SQL queries, inspecting schemas, and performing CRUD operations.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Raja SQL MCP show the schema of the users table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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)
Related MCP server: mcp-sqlite
Installation
pip install raja-sql-mcpRunning the Server
sql-mcpOr during development:
uv run python -m src.sql_mcp.mainMCP Inspector Configuration
Transport
STDIOCommand
uvArguments
run python -m src.sql_mcp.mainWorking Directory
/path/to/SQL_MCPAvailable 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.lockUse 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
Available Tools
7 toolsdelete_dataC
Delete Data from your table
Inputs: condition (required), table_name (required).
describe_tableC
This function allows you to get schema of given table name
Inputs: table_name (required).
execute_selectC
Execute SELECT Queries and returns rows
Inputs: query (required).
execute_sqlC
This function helps to execute an sql query
Inputs: query (required).
insert_dataD
Insert Data into the table
Inputs: data (required), table_name (required).
list_tablesA
Get all the tables in your Database
Inputs: no named parameters.
update_dataD
Update data in the Table
Inputs: data (required), condition (required), table_name (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 7 tools
Tools are mostly distinct, but execute_select and execute_sql have overlapping functionality since both can run SELECT queries, potentially confusing an agent.
All tools follow a consistent verb_noun pattern (e.g., delete_data, describe_table, execute_sql), with no mixing of conventions.
7 tools is a well-scoped set for a SQL database server, covering essential operations without being excessive or insufficient.
Covers core CRUD and schema inspection, but lacks dedicated tools for table creation or alteration, though execute_sql can handle them.
Maintenance
Related MCP Connectors
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
MCP server for interacting with the Supabase platform
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA lightweight MCP server that provides read-only access to SQLite databases, allowing users to execute SELECT queries, list tables, and describe table schemas.1MIT
- FlicenseNot gradedqualityDmaintenanceMCP server that provides SQLite database operations. Allows AI assistants to query, modify and manage SQLite databases through the Model Context Protocol.-
- AlicenseNot gradedqualityDmaintenanceAn MCP server for working with encrypted SQLite databases (SQLCipher), enabling database exploration, SQL queries, and CRUD operations through natural language.Apache 2.0
- AlicenseNot gradedqualityCmaintenanceAn MCP server providing SQLite database access for AI agents, enabling SQL execution, schema inspection, CRUD operations, and data export.MIT