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.

Zur Installation springen

Repository: wardawgmalvicious/agent-config
Letzte Quellaktivität: 16. September 2026 um 03:22
Erkannte Sprache von SKILL.md: Englisch
Sterne: 1
Forks: 0

Installationsoptionen

Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.

Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.

Ein direkter Befehl überspringt den Prüf-Prompt. Prüfen Sie die Quelle, bevor Sie ihn ausführen.

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

Der Befehl bleibt in einer Zeile. Scrollen Sie horizontal, um ihn vor dem Kopieren vollständig zu prüfen.

Sie bevorzugen eine lokale Kopie? Laden Sie die Dateien herunter, die SkillsMP derzeit vorliegen.

Quelldateien prüfen

Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.

Datei-Explorer

2 Dateien

SKILL.md

Quellanweisungen · Schreibgeschützte Vorschau

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"]
disable-model-invocation: false

# 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

Auf GitHub ansehen

Zurück zur Suche Zurück zur Installation

fabric-gotchas

Use when troubleshooting Microsoft Fabric — common errors: 401 (wrong token audience), 403 on Power BI API (Viewer role), 404 EntityNotFound (permissions masquerading), PowerBIEntityNotFound (logicalId vs runtime ID), Login failed (wrong Initial Catalog), 24556/24706 snapshot conflict, nvarchar/datetime/money errors (Warehouse unsupported types), COPY INTO auth, MERGE/ALTER COLUMN failures, TMDL validation (tabs vs spaces, /// comments), DefaultJob jobType mistake, sqlcmd version, slow SQLEP (small files), notebook `400 exceptionCulprit:1` (bare-string cell source), Variable Library `InvalidContent (ValueMismatch)` (stale override / empty value), greyed-out deployment-rule dropdowns (Direct Lake), DirectQuery-transformations refresh error, PBIR-Legacy format, MissingDefinitionParts, empty visuals after publish (byConnection rebind), empty Top-N visuals + frozen save (bad TopN filter), RTDB `baseQueryId` error, Runtime 2.0 `LibraryManagementError`, warehouse 2.0 Git sync `DataLoss` block (pre-drop live).

2026-09-21

fabric-warehouse

Use for T-SQL against Fabric Warehouse (NOT Fabric SQL Database — see fabric-database). Covers unsupported types (nvarchar/datetime/money/xml/tinyint/hierarchyid), unsupported features (FOR XML, recursive CTEs, triggers, CREATE USER, cursors), MERGE (GA Jan 2026), ALTER COLUMN (preview), schema evolution (ADD nullable / DROP COLUMN / sp_rename, IDENTITY GA Aug 2026 (bigint, RESEED), transactional ALTER TABLE GA April 2026, CTAS workaround), PK/UNIQUE/FK NONCLUSTERED+NOT ENFORCED only, 8060-byte row limit, CTAS Synapse-vs-Fabric rules (no DISTRIBUTION/CCI/variables), COPY INTO with AUTO_CREATE_TABLE + bcp (preview), OPENROWSET surface, snapshot-only isolation (24556/24706 retry), DDL in transactions (Sch-M blocks reads), Time Travel (UTC, single per SELECT; SQLEP preview) + Warehouse Snapshots (GA), sp_get_table_health_metrics (SQLEP), GPU acceleration (preview), Recycle-bin recovery, Git/CI-CD 2.0 (DacFx DataLoss sync block, .sqlproj SDK pin, SQLEP), pipeline calls via Script activity (NOT Stored Procedure).

2026-09-21

learn

Routes a session learning into the durable guidance that should have covered it — a SKILL.md and its references/, a path-scoped rule, a CLAUDE.md — rather than into auto-memory. Reconstructs which skills and rules were actually loaded instead of asking, checks existing coverage before writing, verifies the learning against official docs or a second reproduction, and proposes the edit as a diff at the heading where a reader would look. Never edits silently, never writes domain knowledge to memory, never appends a changelog section. Inside the repo that sources ~/.claude it edits the payload directly and hands off to /commit. In any other repo it edits nothing and writes a dated note to the local handoff inbox instead, because the guidance lives in a repo that session is not in. To create guidance that has no home yet, use author-skill.

2026-09-18

Alle aus diesem Repository ansehen

fabric-database

Quellinformationen

Installationsoptionen

Quelldateien prüfen

Mehr aus diesem Repository

Mehr aus diesem Repository