Databases_mcp_server
About
Created a MCP Server that connects to databases(currently sqlite, mysql) and perform queries on them automatically with natural language.
Details
- Author
- jaiganesh-23
- Downloads
- 326
- Categories
- Database
Jump to
- Connects to SQLite and MySQL databases
- Enables natural language querying of databases
- Simple JSON configuration for VS Code
- Uses the Model Context Protocol (MCP)
Configure the server in VS Code’s MCP settings using the provided JSON snippets. For MySQL, supply the database type flag (--mysql) along with host, database, user, and password. For SQLite, provide the absolute path to the index.js script followed by the database file path. Once configured, natural language queries can be sent to the server via an MCP chat interface.
Created a MCP Server that connects to databases(currently sqlite, mysql) and perform queries on them automatically with natural language.<br><br><br>
Usage with VS Code<br><br>
For Mysql
"mcp": {
"inputs": [],
"servers": {
"mysql": {
"command": "node",
"args": [
"absolute/path/to/index.js",
"--mysql",
"--host","host",
"--database","database",
"--user","user",
"--password","password",
]
}
}
}
For Sqlite
"mcp": {
"inputs": [],
"servers": {
"sqlite": {
"command": "node",
"args": [
"absolute/path/to/index.js",
"absolute/path/to/database.db",
]
}
}
}
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
