Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MCP Excel-PostgreSQL Import sales.xlsx into the 'sales' table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Este servidor implementa el Model Context Protocol (MCP) para conectar asistentes de IA (como Claude Desktop) con tus datos locales. Permite leer y editar archivos Excel y realizar consultas a bases de datos PostgreSQL de forma segura y directa, facilitando flujos de trabajo de análisis de datos sin necesidad de exportaciones manuales.
Clona el repositorio e instala las dependencias:
npm installCompila el servidor (genera los archivos en dist/):
npm run buildRelated MCP server: Excel MCP Server
Agregar a tu configuración MCP (~/.MPC/mcp.json o Claude Desktop config):
{
"mcpServers": {
"excel-mcp-server": {
"command": "node",
"args": ["/path/to/your/project/dist/main.js"],
"cwd": "/path/to/your/project",
"env": {
"POSTGRES_USER": "your_user",
"POSTGRES_HOST": "localhost",
"POSTGRES_DB": "your_db",
"POSTGRES_PASSWORD": "your_password",
"POSTGRES_PORT": "5432"
}
}
}
}Excel: read_excel, write_excel, update_excel
PostgreSQL: connect_database, execute_query, create_table, insert_data, list_tables, describe_table, get_database_info
Integración: export_to_excel, import_from_excel
Lee un archivo Excel y devuelve los datos en formato JSON
Inputs: filePath (required), sheetName, hasHeaders.
Escribe datos a un archivo Excel
Inputs: data (required), filePath (required), headers, sheetName.
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Scored across 2 tools
The two tools have completely distinct purposes: one reads Excel files, the other writes them. There is no possibility of confusion between read_excel and write_excel.
Both tools follow a clear verb_excel pattern (read, write), making the naming predictable and consistent.
Only 2 tools are provided, which is too few given the server name 'Excel-PostgreSQL' implies handling both Excel and PostgreSQL data. Even ignoring the PostgreSQL part, basic Excel operations like listing sheets or modifying specific cells are missing.
The tool surface is severely incomplete for a server claiming to cover both Excel and PostgreSQL. With only read and write for Excel, and no PostgreSQL tools at all, agents will lack essential capabilities.
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
AI access to Quadratic spreadsheets: open files, run Python/SQL, query connected databases.
File tools for your AI chat: PDF tables to Excel, merge PDFs, images to PDF, fill PDF forms.
Every spreadsheet is a table: Excel, CSV, Parquet and JSON as SQL tables for AI agents.
