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., "@Claude MCP Data Engineer Server Generate a dbt model for my raw.orders table with deduplication."
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.
A Model Context Protocol (MCP) server built for data engineers — gives Claude powerful tools to help with SQL, DBT, Snowflake, CSV analysis, pipeline validation, and ETL lineage.
Tool | Description |
| Format & prettify SQL queries with proper indentation |
| Generate CREATE TABLE DDL from a JSON sample record |
| Analyze CSV data — row count, column types, null counts |
| Generate a dbt model SQL file with source + deduplication CTE |
| Validate a data pipeline JSON config for required fields |
| Generate a Snowflake CREATE TABLE with optional CLUSTER BY |
| Summarize ETL lineage JSON into a human-readable pipeline flow |
Related MCP server: Snowflake Developer MCP Server
pip install -r requirements.txtpython -m src.serverAdd this to your claude_desktop_config.json (~/AppData/Roaming/Claude/ on Windows):
{
"mcpServers": {
"data-engineer": {
"command": "python",
"args": ["-m", "src.server"],
"cwd": "C:/Users/Nikhil/claude-mcp-data-engineer"
}
}
}Ask Claude:
"Format this SQL: select id,name from users where status='active' group by id"
Ask Claude:
"Generate a CREATE TABLE DDL for this JSON:
{"id": 1, "name": "Nikhil", "salary": 95000.0, "joined": "2024-01-15"}"
Ask Claude:
"Analyze this CSV data and tell me column types and null counts"
Ask Claude:
"Generate a dbt model for source 'raw', table 'orders', columns: id, customer_id, amount, created_at"
Ask Claude:
"Validate this pipeline config:
{"source": {"type": "snowflake"}, "destination": {"type": "s3"}, "schedule": "0 2 * * *"}"
Python 3.10+
MCP SDK (mcp[cli])
FastMCP for server definition
Nikhil E — Sr. Data Engineer | BI Architect GitHub: itsnikhile
This server cannot be deployed
Your Databricks Lakehouse in natural language: run SQL on your SQL warehouses, track long-running qu
The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over your data.
Generate, edit, and export data-architecture diagrams from your AI. Column lineage, PNG in chat.
Ask data questions in natural language. Get SQL, insights, and charts from your databases.
