update_databaseLABSCO SUMMARY
The spreadsheet-into-a-table job, without a one-off script that then lives forever.
One call takes the file path, the database type, the connection string and the table name, so the same tool covers a Postgres load and a SQLite one — and the notes tool gives you somewhere to record what an import changed while the detail is still fresh.
What it is
A loader that reads a CSV or Excel file from a path you give and writes it into a table on a database you name, plus a small notes tool for recording what was done.
What you get
- CSV and Excel files read, including .xlsx and .xls
- PostgreSQL, MySQL, MongoDB and SQLite as targets
- Connection string, database type, source file and target table all passed per call
- Notes created and kept alongside, for tracking what an update changed
Requirements
A connection string for the target database, supplied on each call rather than configured once, and a file path the server can read. Node, with the project built locally before first use.
Setup effort
Build from source
USE CASES
01
Loading a spreadsheet someone emailed you into a real table
Point the call at the .xlsx and name the target table — no conversion step and no throwaway script.
02
Seeding a local database for testing
Push a CSV into SQLite or Postgres with the connection string for that environment.
03
Running the same import against a different engine
Change the database type and connection string on the call; the file and table arguments stay as they were.
04
Leaving a record of what an import did
Write a note with the file, the table and the date, so the next person is not guessing where the rows came from.
2 tools
Listed in project docs. Your client may show a different list.
create_noteBEFORE YOU INSTALL
What to know first
Tools you get
2 tools named in the project's documentation.
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
You clone and build this one yourself.
Server setup
TERMINAL
git clone https://github.com/AnuragRai017/database-updater-MCP-Server
cd database-updater-MCP-Server
npm install
npm run buildAdd the mcpServers block below to ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%/Claude/claude_desktop_config.json (Windows)
MCP Clients
Any MCP client
ANY MCP CLIENT · JSON
{
"mcpServers": {
"database-updater": {
"command": "<YOUR_PATH_TO_DATABASE_UPDATER>/build/index.js"
}
}
}
