databases_mcp_server
This project aims to implement database server functionalities using JavaScript. It supports basic CRUD operations, allowing for data storage and retrieval. However, due to a lack of documentation and testing, the quality cannot be considered excellent.
GitHub Stars
0
User Rating
Not Rated
Favorites
0
Views
21
Forks
0
Issues
0
README
Created a MCP Server that connects to databases(currently sqlite, mysql, postgresql and sqlserver) and perform queries on them automatically with natural language.
Usage with VS Code
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",
]
}
}
}
For Postgresql
"mcp": {
"inputs": [],
"servers": {
"mysql": {
"command": "node",
"args": [
"absolute/path/to/index.js",
"--postgresql",
"--host","host",
"--database","database",
"--user","user",
"--password","password",
"--ssl","true",
]
}
}
}
For Sqlserver
"mcp": {
"inputs": [],
"servers": {
"mysql": {
"command": "node",
"args": [
"absolute/path/to/index.js",
"--sqlserver",
"--server","server",
"--database","database",
"--user","user",
"--password","password",
]
}
}
}