mcp-databricks
Provides tools for interacting with Databricks SQL and metadata, including table discovery, column alterations, and DDL operations.
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-databricksshow me the tables in the default schema"
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.
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
This server cannot be deployed
Maintenance
Related MCP Connectors
Governed data discovery, exact queries, decisions, simulations, and runtime utilities over MCP.
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Remote data science agents for Snowflake, Databricks & BigQuery in Claude/Cursor via MCP
Related MCP Servers
- AlicenseCqualityDmaintenanceA read-only MCP server that enables users to query Databricks SQL, browse metadata, and monitor Delta Lake tables. It also supports tracking Databricks Jobs, DLT Pipelines, and cluster metrics through natural language interfaces.254MIT
- AlicenseNot gradedqualityDmaintenanceExposes Databricks REST API as MCP tools for managing clusters, jobs, notebooks, SQL queries, Unity Catalog, and more. Enables AI agents to interact with Databricks workspaces through natural language.50MIT
- AlicenseNot gradedqualityDmaintenanceMCP server for executing Databricks SQL queries and comparing table data, supporting CLI and VS Code integration.1MIT
- AlicenseCqualityDmaintenanceExposes Databricks REST APIs as MCP tools for managing and querying a Databricks workspace, including clusters, jobs, SQL, Unity Catalog, and more.100MIT