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
