Database Bulk Update
About
Streamlines database updates from CSV and Excel files, supporting multiple database types for efficient data migration and synchronization tasks.
Details
- Author
- anuragrai017
- Repository
- AnuragRai017/database-updater-MCP-Server
- GitHub stars
- 1
- Downloads
- 160
- License
- Apache License 2.0
- Categories
- Productivity, Developer Tools, Design, File Management, AI, Knowledge Base, Frontend, Automation, Database, Other
Jump to
- update_database tool for importing CSV and Excel files
- Supports PostgreSQL, MySQL, MongoDB, SQLite databases
- create_note tool for documenting database updates
- Configurable connection settings and table mapping
- Written in Node.js; uses stdio transport
- Includes MCP Inspector support for debugging
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Database Bulk UpdateCommand (node, npx, python, etc.)nodeArguments-
Argument 1
/path/to/database-updater/build/index.js
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
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. Supports CSV and Excel (.xlsx, .xls) file formats and compatible with multiple database types (PostgreSQL, MySQL, MongoDB, SQLite).
create_note
Create and manage notes for documentation. Store important information about database updates and track changes and modifications.
- 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
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"database bulk update": {
"cwd": null,
"env": {},
"args": [
"/path/to/database-updater/build/index.js"
],
"shell": false,
"command": "node"
}
}
}Linux
{
"cwd": null,
"env": [],
"args": [
"/path/to/database-updater/build/index.js"
],
"shell": false,
"command": "node"
}Macos
{
"cwd": null,
"env": [],
"args": [
"/path/to/database-updater/build/index.js"
],
"shell": false,
"command": "node"
}Windows
{
"cwd": null,
"env": [],
"args": [
"/path/to/database-updater/build/index.js"
],
"shell": false,
"command": "node"
}A Model Context Protocol server for updating databases from CSV and Excel files.
-
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
Use theupdate_databasetool with the following parameters:
{ "filePath": "/path/to/your/file.csv", "databaseType": "PostgreSQL", "connectionString": "postgresql://user:pass@localhost:5432/db", "tableName": "target_table" }
To use with Claude Desktop, add the server config:
On MacOS:~/Library/Application Support/Claude/claude_desktop_config.jsonOn Windows:%APPDATA%/Claude/claude_desktop_config.json
{ "mcpServers": { "database-updater": { "command": "/path/to/database-updater/build/index.js" } } }
Since MCP servers communicate over stdio, debugging can be challenging. We recommend using theMCP Inspector:
The Inspector will provide a URL to access debugging tools in your browser.
Multi-database agent access (PostgreSQL, SQLite, MySQL, Oracle, SQL Server) with batch queries, pre-configured connections, and SQLGlot-enforced read-only safety
Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite
A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite
A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.
Enables AI assistants to interact with various databases through JDBC connections.
Production-grade Model Context Protocol (MCP) server for unified SQL database access. Connect multiple databases through a single MCP server with schema discovery, relationship mapping, caching, and safety controls.
Connects to and interacts with various database systems like SQLite, PostgreSQL, SQL Server, and MongoDB.
Provides database access for SQLite, SQL Server, PostgreSQL, and MySQL.
Multi-database analysis MCP server (PostgreSQL, MySQL, SQLite). Inspects schemas, detects index problems, analyzes table bloat, and explains query plans for actionable database optimization.
A lightweight MCP server for any database with a JDBC driver. Built with Quarkus and requires Java 21+.
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
