Databricks

File Structure

mcp-databricks/
├── .env                  # Environment variables (DATABRICKS_HOST, TOKEN, etc.)
├── Dockerfile            # Containerization for deployment
├── README.md
├── pyproject.toml      # or requirement.txt
└── src/
    ├── __init__.py
    ├── server.py           # Server entrypoint, initializes MCP server and registers tools
    ├── config.py         # Configuration management using Pydantic Settings
    ├── db/
    │   ├── __init__.py
    │   ├── client.py     # Databricks SQL connection pool / Databricks SDK client
    │   └── operations.py # Low-level SQL execution & metadata query logic
    ├── models/
    │   ├── __init__.py
    │   ├── metadata.py   # Pydantic models for Table/Column schemas and discovery
    │   └── operations.py # Pydantic models for Alter/Write request payloads
    └── tools/
        ├── __init__.py
        ├── metadata.py  # MCP tools for reading tables and discovery
        └── warehouse.py # MCP tools for altering columns and DDL operations