fabric-database

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.

Jump to install

Repository: wardawgmalvicious/claude-config
Last source activity: May 7, 2026 at 16:34
Detected SKILL.md language: English
Stars: 2
Forks: 1

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/wardawgmalvicious/claude-config --skill fabric-database

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

2 files

SKILL.md

Source instructions · Read-only preview

name: fabric-database
description: 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.
paths: ["**/*.SQLDatabase/**/*.sql"]

# 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)](https://learn.microsoft.com/fabric/database/sql/overview) - Microsoft Learn: [Features comparison: Azure SQL Database vs Fabric SQL database](https://learn.microsoft.com/fabric/database/sql/feature-comparison-sql-database-fabric) - Microsoft Learn: [Limitations in SQL database in Fabric](https://learn.microsoft.com/fabric/database/sql/limitations) - Comprehensive MS Learn link bundle (concept / create+connect / limitations / OneLake mirroring / security / backup / source control & SqlPackage / GraphQL / billing): [references/REFERENCE.md](references/REFERENCE.md) ## See also - fabric-warehouse skill — the distributed DW engine with its own restrictions - fabric-auth skill — `database.windows.net` token audience

View on GitHub

Back to search Back to installation

fabric-cicd

Use for the fabric-cicd Python library (`pip install fabric-cicd`, v1.3 Aug 2026, Python 3.9–3.13) — Microsoft's official code-first CI/CD library for Fabric workspaces: `FabricWorkspace`, `publish_all_items`, `unpublish_all_orphan_items`, `deploy_with_config` + config.yml, and `parameter.yml` (find_replace, key_value_replace, spark_pool, semantic_model_binding, $workspace/$items dynamic vars, $ENV:, _ALL_, regex, extend). Covers the explicit-TokenCredential requirement (v1.0 breaking change), feature flags (enable_lakehouse_unpublish, enable_bulk_publish, enable_shortcut_publish, enable_hard_delete, include/exclude), per-item-type caveats (Warehouse/SQL DB, Lakehouse, Variable Library), Azure DevOps / GitHub Actions + OIDC, Fabric notebook usage, and troubleshooting (change_log_level, FABRIC_CICD_FILE_LOGGING_ENABLED, configure_fabric_fqdn). Invoke when the user mentions fabric-cicd, FabricWorkspace, publish_all_items, parameter.yml, or code-first Fabric deployment from Git.

2026-08-18

fabric-cli

Use for the Fabric CLI `fab` (v1.5 GA March 2026, `pip install ms-fabric-cli`, Python 3.10–3.13, pre-installed in Fabric Notebooks) — filesystem-style CLI over Fabric + Power BI REST. Covers path syntax (Workspace.Workspace/Item.ItemType, .ItemType suffix mandatory, hidden roots .capacities/.connections/.domains/.gateways), auth reuse from `az login`, navigation (ls/cd/pwd/exists/get/desc/find), item CRUD (mkdir/set/rm/cp/mv/ln/export/import), ACLs, capacity/domain assign, labels, jobs (incl. semantic-model refresh + dataflow), table maintenance, shortcuts via `fab ln`, `fab deploy --config <yaml>` for one-command workspace CI/CD on top of fabric-cicd (v1.5+), `fab api` REST passthrough (-A powerbi/storage/azure), deployment pipelines, report rebind via `fab set semanticModelId`, DuckDB-on-OneLake, executing DAX via fab api, and common gotchas (InvalidPath, GUID vs friendly names for schema tables, -f for non-interactive).

2026-08-18

commit

Use when asked to commit changes — /commit, 'commit this', 'make the commits', 'commit these split logically'. Splits working-tree changes into logical, self-consistent commits (ordering so nothing dangles, stepping files that straddle commits through intermediate states), writes conventional-commit messages (feat/fix/docs/refactor/chore) with motivation in the body, stages explicit paths only, uses git mv for renames, never pushes/amends/skips hooks unless explicitly asked, and ends by reporting the resulting hashes against a clean tree. Includes pre-commit checks for Fabric Git-synced repos (core.autocrlf, .gitattributes, whitespace-only portal diffs).

2026-08-17

View all from this repository

fabric-database

Source facts

Install options

Review the source files

More from this repository

More from this repository