raja_sql_mcp

# 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 ```bash pip install raja-sql-mcp ``` --- ## Running the Server ```bash sql-mcp ``` Or during development: ```bash uv run python -m src.sql_mcp.main ``` --- ## MCP Inspector Configuration ### Transport ```text STDIO ``` ### Command ```text uv ``` ### Arguments ```text run python -m src.sql_mcp.main ``` ### Working Directory ```text /path/to/SQL_MCP ``` --- ## Available Tools ### `list_tables()` Returns all tables in the database. Example: ```python list_tables() ``` --- ### `describe_table(table_name)` Returns the schema of the specified table. Example: ```python describe_table("users") ``` --- ### `execute_sql(query)` Executes SQL queries such as: - CREATE TABLE - INSERT - UPDATE - DELETE - DROP TABLE - ALTER TABLE Example: ```python execute_sql(""" CREATE TABLE users( id INTEGER PRIMARY KEY, name TEXT, age INTEGER ) """) ``` --- ### `execute_select(query)` Executes SELECT queries and returns rows. Example: ```python execute_select( "SELECT * FROM users" ) ``` --- ### `insert_data(table_name, data)` Insert records dynamically. Example: ```python insert_data( "users", { "name": "Raja", "age": 21 } ) ``` --- ### `update_data(table_name, data, …