mcp-csv-postgres

# CSV to PostgreSQL MCP Server An MCP (Model Context Protocol) server that loads CSV files into PostgreSQL databases with validation and progress tracking. ## Features - **CSV Validation**: Validates CSV structure and provides detailed error messages - **Efficient Loading**: Uses PostgreSQL COPY command for fast bulk loading - **Progress Tracking**: Shows progress bar for long-running imports - **Flexible Configuration**: Optional database name (defaults to `csvimports`) - **Error Reporting**: Exact line numbers and column information for validation errors ## Installation ### From PyPI ```bash pip install mcp-csv-postgres ``` Or using `uv`: ```bash uv pip install mcp-csv-postgres ``` ### From Source Clone the repository and install with `uv`: ```bash git clone https://github.com/raviramadoss/mcp-csv-postgres.git cd mcp-csv-postgres uv sync --all-extras ``` ## Usage ### As MCP Server #### Option 1: After installing from PyPI Add to your Claude Desktop configuration file (`~/Library/Application Support/Claude/claude_desktop_config.json` on macOS): ```json { "mcpServers": { "mcp-csv-postgres": { "command": "uv", "args": [ "tool", "run", "--from", "mcp-csv-postgres", "mcp-csv-postgres" ] } } } ``` #### Option 2: For local development ```json { "mcpServers": { "mcp-csv-postgres": { "command": "uv", "args": [ "tool", "run", "--from", "/path/to/mcp-csv-postgres", "--python", "3.10", "mcp-csv-postgres" ] } } } ``` Or run directly from command line: ```bash mcp-csv-postgres ``` ### Tool: `load_csv_to_postgres` Loads a CSV file into PostgreSQL database. **Parameters:** - `file_path` (required): Path to the CSV file - `dbname` (optional): Database name (default: `csvimports`) - `host` (optional): PostgreSQL host (default: `localhost`) - `port` (optional): PostgreSQL port (default: `5432`) - `user` (o…