-
securityF
license-
qualityA server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.
Last updated -
Allows importing data from CSV and Excel files into MongoDB databases
Allows importing data from CSV and Excel files into MySQL databases
Allows importing data from CSV and Excel files into PostgreSQL databases
Allows importing data from CSV and Excel files into SQLite databases
database-updater MCP Server
A Model Context Protocol server for updating databases from CSV and Excel files.
Features
Tools
update_database- Update database from CSV/Excel filesSupports 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 the update_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
SQLite
Development
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.
Related MCP Servers
- -securityFlicense-qualityA natural language interface that allows Claude to execute SQL queries on your local MySQL databases, enabling database interaction using natural language.Last updated -2
- -securityFlicense-qualityProvides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.Last updated -
- -securityAlicense-qualityProvides Claude with direct access to databases including SQLite, SQL Server, PostgreSQL, and MySQL, enabling execution of SQL queries and table management through natural language.Last updated -16,8381MIT License