mcpField
D
database-updater MCP Server

database-updater MCP Server

Local
glama.aiDatabases1Updated 30w ago
RepositoryVisit website

About database-updater MCP Server

An MCP server for importing CSV and Excel data into PostgreSQL, MySQL, MongoDB, or SQLite. It also provides notes for documenting database updates.

Key features

  1. 01Import CSV and Excel files
  2. 02Support four database types
  3. 03Configure connections and table mapping
  4. 04Create notes about updates
  5. 05Track database changes

Use cases

  1. 01Load spreadsheet data into a database
  2. 02Map a file to a target table
  3. 03Document database modifications

MCP support

Exposes `update_database` for importing files and `create_note` for recording update information to MCP clients.

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

database-updater MCP Server

database-updater-MCP-Server MCP server

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 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.

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.