Krusgraph

Krusgraph finds the keys and relationships of your Microsoft Fabric tables and checks them against the rows; this repository is the Krusgraph source

The package is called fabric-backend: the engine, the MCP server, the website and the deployment of Krusgraph, open source under the MIT licence.

See how your tables connect: the rule behind every proposed link, and the row counts once you run the check.

• Checked against your rows: every link shows its basis and the checks you run show their counts.
• Errors before anyone sees them: the total that doubles, keys that are not unique, references with no matching row.
• SAP knowledge from public sources (krusgraph.com/sap): keys with MANDT and the order-to-cash links for VBAK, VBAP and their neighbours, each with its source. A second pack describes Younium subscription billing beside Salesforce (accounts and their External CRM Id, subscription versions, charges, invoices with lines, payments); its sources could not be opened from the session that wrote it and it is marked unverified throughout; the engine applies it since round n78 when a schema has a table of the systems' own (subscription versions, charge plans, opportunity line items), never on tables called accounts or invoices alone (docs/YOUNIUM-SALESFORCE.md). The pack for the Nordic ERP systems is a spike so far (docs/NORDIC-PACK-SPIKE.md).
• One checked plan, every starting point: in Fabric, from the plan you reviewed, Krusgraph creates silver and gold notebooks, a pipeline, a semantic model, a report and an ontology (each created live on synthetic data); creating a data agent or a new item for an API for GraphQL is experimental (an existing API was updated in place live), and an App (preview) is built by Krusgraph for Fabric only; the silver and gold tables fill when the pipeline runs. On /check, in your browser, the same plan gives drafts.

Hosted as [Krusgraph](https://krusgraph.com): https://krusgraph.com/mcp/connect for Claude (with "Register automatically") and for VS Code, Cursor and other MCP clients that register themselves (signed in and used on 27 October 2026 from VS Code, Cursor and Glama); Claude connectors added earlier at https://krusgraph.com/mcp keep working; sign-in with your Microsoft work account, every call with your own Fabric permissions. The guided demo and the demo graph run the same engine on a synthetic schema and need no account. This repository is the whole thing: engine, MCP server, website and deployment. Krusgraph is independent and not affiliated with Microsoft; "Microsoft Fabric" is used descriptively.

Try it without an account: [krusgraph.com/check](https://krusgraph.com/check). No account, no Fabric and no administrator needed. Drop CSV or Excel files, or paste a list of columns, and see how the tables connect and what is wrong with them. The files are read in your browser and are not uploaded. No files at hand? Five synthetic examples are one click away:

• A total that doubles: the shop (fabric_backend/seed.py, seven tables), the default sample everywhere.
• SAP sales tables: SAP-shaped sales, delivery and billing tables of two clients (fabric_backend/sap_demo.py).
• Salesforce + ERP: accounts on one side, an ERP's customers and orders on the other (fabric_backend/browser_check.py).
• Subscription billing: Younium- and Salesforce-shaped invoices (fabric_backend/younium_demo.py).
• Manufacturing sample: a fictional workshop with sixteen tables of its own design (customers, items, bills of materials, work centers, sales, purchase and production orders, stock movements, deliveries), two years of dates and a few planted problems to find (docs/SAMPLE-MILL.md, fabric_backend/mill.py). To try it in Fabric: seed(spark, mill=True) writes it to a schema mill next to shop.

The problem. You have a lakehouse or warehouse in Fabric and you want an app on top of it — in Lovable, or generated by an agent in Cursor or Claude Code. Those tools can read a Fabric *API for GraphQL* item. They cannot make one. So before the first line of app code you spend an afternoon in the portal: create the GraphQL item, pick tables, define every relationship by hand (no relationships, no nested queries), register a service principal, grant it on the item, turn on introspection, copy the endpoint. Then the schema changes and you do the relationships again.

Microsoft's own GraphQL MCP server queries an API that already exists. Lovable's Fabric connector consumes one. As far as we have found (October 2026), nothing provisions one from inferred relationships; if you know of something that does, open an issue.

What this does. Reads the tables, infers keys and relationships from names (declared constraints win when a warehouse has them), writes the GraphQLApi item definition with ManyToOne / OneToMany relationships, creates the item — or updates it in place when the name exists — and prints the endpoint plus the two portal clicks the API cannot do yet.

%pip install git+https://github.com/Krusmaster/fabric-backend[deploy]

import fabric_backend as fb

out = fb.create(workspace=" ", source="my_lakehouse", name="shop_api", spark=spark, keys={"order_items": ["order_id", "line_no"]}) # optional here: rule K5 infers this one; keys overrides print(out["plan"].summary()) print(out["card"])

7 tables, 6 with keys, 6 relationships no key (query only; can reference others, cannot be referenced): audit_log GraphQL endpoint: https://api.fabric.microsoft.com/v1/workspaces/ /graphqlapis/ /graphql Still to do in the Fabric portal (no API for these yet): [ ] shop_api -> Settings -> Introspection -> On (workspace admin; Lovable needs this) [ ] shop_api -> Manage permissions -> add the service principal with 'Run Queries and Mutations'

Paste the endpoint, tenant id, client id and secret into Lovable's Fabric connector. Done.

Same thing from an agent (MCP)

pip install "fabric-backend[mcp]"

FABRIC_ODBC="Driver={ODBC Driver 18 for SQL Server};Server= ;Database= ;Authentication=ActiveDirectoryInteractive" \ fabric-backend-mcp

The same engine over the one connection in FABRIC_ODBC: list_tables, plan_backend (keys, relationships, Mermaid — nothing deployed), validate_plan, sample_rows, create_backend, rayfin_connector, ontology_draft, semantic_model_draft, join_path, data_dictionary, dbt_schema, analyze_schema, suggest_relationships and create_views (dry run by default). The tools that need Fabric item ids (describe_backend, plan_drift, app_starter, create_semantic_model, create_data_agent) live in the remote server only. Set FABRIC_SOURCE_KIND (Lakehouse, Warehouse, SQLDatabase) and FABRIC_SCHEMAS_ENABLED=1 for a lakehouse created with schemas so that semantic_model_draft writes schemaName; SQLServer for an on-prem or Azure SQL Server, where the two Fabric-only drafts answer with an explanation. Windows set-up with Claude Desktop, Windows sign-in and what works locally: docs/LOCAL.md. fabric-backend demo is the 20-minute demo on a laptop: one local page on 127.0.0.1 with the map, the health check with Accept / Skip and five questions run on the customer's own SQL Server or on a folder of CSV / Excel files; script in docs/DEMO-20-MIN.md. Add the stdio server to Claude Desktop (docs/LOCAL.md) or another MCP client that starts local stdio servers; only the Claude Desktop set-up is documented. The agent can then say *"give me a GraphQL API over orders, customers and products"* and get an endpoint back.

Remote server (Krusgraph: Claude, VS Code, Cursor and other MCP clients)

Add https://krusgraph.com/mcp/connect in Claude under Customize → Connectors → Add → Add custom connector, keep "Register automatically" selected and sign in with your Microsoft work account; your Entra admin consents once (https://krusgraph.com/start has the steps, https://krusgraph.com/docs the details). Why /mcp/connect: on 8 November 2026 Claude's new connector dialog registers itself as a client, which https://krusgraph.com/mcp does not offer ("Automatic client registration isn't supported"); connectors added there earlier keep working. VS Code, Cursor and other MCP clients that register themselves use the same https://krusgraph.com/mcp/connect: Krusgraph shows its own approval page for the client, then the Microsoft sign-in (https://krusgraph.com/docs#other-mcp-clients; tested on 27 October 2026 with VS Code, Cursor and Glama; docs/CLIENT-REGISTRATION.md). The first message after connecting: start Krusgraph, a guided path one step at a time that only reads until you confirm the names after a dry run (docs/START-KRUSGRAPH.md). To run your own:

docker build -t fabric-backend-server . && docker run -p 8000:8000 \

-e FABRIC_TENANT_ID=... -e FABRIC_CLIENT_ID=... -e FABRIC_CLIENT_SECRET=... fabric-backend-server

Streamable HTTP at /mcp, forty tools, every one with a title and a readOnlyHint/destructiveHint (the directory requires it): list_workspaces, list_sources, list_tables, plan_backend (nothing deployed; suggests composite keys), sample_rows, validate_plan (keys and relationships checked against the rows; by default a summary with every failing check in full, detail="full" for every check), create_backend (creates or updates one item, never deletes), describe_backend, query_graphql (read-only; mutations refused), rayfin_connector and ontology_draft; every tool takes the workspace by id or name. Five more read-only tools turn the same plan into the week's deliverables, all unit-tested and run against the demo workspace (synthetic shop data) on 26 and 27 October 2026:

• semantic_model_draft — a Power BI semantic model in TMDL: Direct Lake tables on the SQL analytics endpoint, relationships with one active path per table pair, suggested measures with their reasons (the row count of each fact table, sums only where summarizeBy sums; never an id, code or year) and, when fact tables have date columns, a calendar marked as the date table; a README.generated.md with the decisions to check (fabric_backend/semantic_model.py cites the Microsoft sample definitions it follows). The measures and the calendar were added after 26 October and came back from the live run of 27 October (summarizeBy: none on ship_to_id).
• join_path — the shortest chain of relationships between two tables, rule per hop, ready T-SQL; or which relationship is missing.
• data_dictionary — hand-over documentation in Markdown with an empty Description column; validate=true adds counts.
• dbt_schema — a dbt sources file with unique, not_null and relationships tests (fabric_backend/dbt.py cites the dbt docs).
• domain_draft — proposed domains (candidate data products) from the plan's graph, the relationships that cross them, unassigned tables and one ODCS v3.2.0 data contract per domain; Fabric domains are created by the customer's admin (docs/DOMAINS.md). Unit tests only.
• plan_drift — today's plan against an existing API for GraphQL item: what a create_backend with that name would change.

Four more tools create things from the same plan, each dry_run=true by default so the first answer is ex