Fabric database

Skill wardawgmalvicious/claude-config/skills/fabric-database

Personal Claude Code config — skills, subagents, hooks, and rules for Microsoft Fabric and Power BI workflows on Windows. Cherry-pickable, no semver.

Install

npx -y skills add wardawgmalvicious/claude-config --skill fabric-database

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

2 stars2 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Use when working with Fabric SQL Database — the Azure SQL Database hosted inside a Fabric workspace. Key point: this is a DIFFERENT engine from Fabric Warehouse and does NOT share its restrictions. nvarchar/datetime/money/triggers/MERGE/ALTER COLUMN/recursive CTEs/FOR XML/temporal tables/full-text search all work. Entra ID auth only (no SQL auth), token audience `database.windows.net`, tables auto-replicate to OneLake as Delta, standard .sqlproj format.

SKILL.md

2.6 KB, as published. Nobody here has run it

Fabric SQL Database

Fabric SQL Database is an Azure SQL Database hosted within a Fabric workspace. It is a completely different engine from Fabric Warehouse and does NOT share the Warehouse's restrictions.

Key Differences from Fabric Warehouse

Feature	Fabric Warehouse	Fabric SQL Database
Engine	Distributed Synapse DW	Azure SQL Database
`nvarchar`, `datetime`, `money`	Not supported	Fully supported
Triggers	Not supported	Fully supported
MERGE	Preview only	Fully supported
ALTER COLUMN	Not supported	Fully supported
Recursive CTEs	Not supported	Fully supported
`FOR XML`	Not supported	Fully supported
Transaction isolation levels	Snapshot only	All levels
`CREATE USER`	Not supported	Fully supported
Temporal tables	Not supported	Fully supported
Full-text search	Not supported	Fully supported

Fabric-Specific Context

Authentication: Entra ID only — SQL auth is not supported in Fabric
Token audience: https://database.windows.net/.default (same as Warehouse)
OneLake replication: Tables automatically replicate to OneLake as Delta/Parquet
SQL projects: Uses standard .sqlproj format for schema-as-code
Do NOT apply Warehouse T-SQL restrictions to Fabric SQL Database code

Reference

Microsoft Learn: SQL database in Fabric (overview)
Microsoft Learn: Features comparison: Azure SQL Database vs Fabric SQL database
Microsoft Learn: Limitations in SQL database in Fabric
Comprehensive MS Learn link bundle (concept / create+connect / limitations / OneLake mirroring / security / backup / source control & SqlPackage / GraphQL / billing): references/REFERENCE.md