execute_sql_queryLABSCO SUMMARY
Two calls, three database engines.
Engine, connection and query all arrive on the same call, which makes it useful for touching a database nobody has set up yet.
What it is
An MCP server for SQL databases with two operations: one executes a query, the other inserts a JSON object as a row. Both take the database type and connection string as arguments, so nothing is configured in advance.
What you get
- SQL executed against MySQL, PostgreSQL or SQLite
- A row inserted into a named table from a JSON object of key-value pairs
- The target chosen per call by dbType and connectionString
- SQLite reached by file path instead of a connection string
Requirements
Node.js with npm install and npm run build; point the client at build/index.js. Each call carries its own dbType and connectionString, so connection details travel with the request rather than living in config.
Setup effort
Build from source
USE CASES
01
Querying a database you have not configured
Pass the type and connection string alongside the query itself.
02
Adding a row without writing INSERT
Give the table name and a JSON object of column values.
03
Poking at a local SQLite file
The connection string is just the path to the file.
04
Running the same query on a different engine
Switch dbType between mysql, postgresql and sqlite and keep the rest of the call.
2 tools
Listed in project docs. Your client may show a different list.
insert_dataBEFORE YOU INSTALL
What to know first
Tools you get
2 tools named in the project's documentation.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
You clone and build this one yourself.
Server setup
TERMINAL
git clone https://github.com/VlaadislavKr/mcp-sql-server
cd mcp-sql-server
npm install
npm run buildPoint your MCP client at the built build/index.js using the mcpServers block below (Claude Desktop MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json)
MCP Clients
Any MCP client
ANY MCP CLIENT · JSON
{
"mcpServers": {
"sql": {
"command": "<YOUR_PATH_TO_SQL>/build/index.js"
}
}
}
