database-updater MCP Server
About
A Model Context Protocol server for updating databases from CSV and Excel files. It supports PostgreSQL, MySQL, MongoDB, and SQLite, and provides configurable connection settings and table mapping.
Details
- License
- Apache-2.0 license
Explore
- Supports CSV and Excel (.xlsx, .xls) files
- Compatible with PostgreSQL, MySQL, MongoDB, SQLite
- Configurable connection string and table mapping
- Includes a create_note tool for tracking changes
- Built with TypeScript and runs as a Node.js process
To use with Claude Desktop, add the server config:
On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"database-updater": {
"command": "/path/to/database-updater/build/index.js"
}
}
}
update_database
Update database from CSV/Excel files
create_note
Create and manage notes (for documentation)
- update_database - Update database from CSV/Excel files
- Supports CSV and Excel (.xlsx, .xls) file formats
- Compatible with multiple database types (PostgreSQL, MySQL, MongoDB, SQLite)
- Configurable connection settings and table mapping
- create_note - Create and manage notes (for documentation)
- Store important information about database updates
- Track changes and modifications
A Model Context Protocol server for updating databases from CSV and Excel files.
Features
Tools
-update_database - Update database from CSV/Excel files
- Supports CSV and Excel (.xlsx, .xls) file formats
- Compatible with multiple database types (PostgreSQL, MySQL, MongoDB, SQLite)
- Configurable connection settings and table mapping
- create_note - Create and manage notes (for documentation)
- Store important information about database updates
- Track changes and modifications
Usage
Update Database
Use theupdate_database tool with the following parameters:
{
"filePath": "/path/to/your/file.csv",
"databaseType": "PostgreSQL",
"connectionString": "postgresql://user:pass@localhost:5432/db",
"tableName": "target_table"
}
Supported Database Types
- PostgreSQL - MySQL - MongoDB - SQLiteDevelopment
Install dependencies:
npm install
Build the server:
npm run build
For development with auto-rebuild:
npm run watch
Installation
To use with Claude Desktop, add the server config:
On MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"database-updater": {
"command": "/path/to/database-updater/build/index.js"
}
}
}
Debugging
Since MCP servers communicate over stdio, debugging can be challenging. We recommend using the MCP Inspector:
npm run inspector
The Inspector will provide a URL to access debugging tools in your browser.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
