Run any Skill in Manus with one click

fabric-database

Stars2

Forks1

UpdatedMay 7, 2026 at 16:34

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.

Installation

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.

Run Skill in Manus

Source

wardawgmalvicious

wardawgmalvicious/claude-config

View GitHub Repository View Creator Repositories

Download

Run Skill in Manus

Related occupationsSOC

Based on SOC occupation classification

Database ArchitectsComputer and Mathematical Occupations·SOC 15-1243

File Explorer

2 files

SKILL.md

readonly

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)
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

Use for Microsoft Fabric Eventstream — the streaming-ingestion item routing CDC / Event Hubs / Kafka / IoT / HTTP / MQTT events into Lakehouse, Eventhouse, Activator, or derived streams, and how external apps produce events to a schema-associated custom endpoint. Covers source connectors (Azure SQL / SQL MI / PostgreSQL / MySQL / MongoDB / Cosmos DB CDC, Mirrored DB Delta CDF preview, Event Hubs / IoT Hub / Kafka / MSK / Confluent / Kinesis / Service Bus / MQTT / HTTP / Solace), DeltaFlow analytics-ready CDC (auto-table + schema evolution), Activator destination + in-Eventstream `Set Alert` flow, three workspace-monitoring KQL tables (`EventStreamNodeStatus`/`EventStreamMetrics`/`EventStreamErrorMetrics`, ~6h status lag) + republish-on-enable, mTLS Key Vault on Kafka, custom-endpoint CloudEvents producer format (binary mode — `cloudEvents:` app properties, `dataschema` version routing), and gotchas (republish required, 6h status lag, filter by ArtifactId not name, CloudEventPropertyMissingException).

2026-07-092

fabric-gotchas

wardawgmalvicious/claude-config

Use when troubleshooting Microsoft Fabric — common errors: 401 (wrong token audience), 403 on Power BI API (Viewer role), 404 EntityNotFound on getDefinition (permissions masquerading), PowerBIEntityNotFound from pipeline/Variable Library (logicalId vs runtime ID confusion), 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), plus the MUST/PREFER/AVOID best-practices summary.

2026-07-082

fabric-eventhouse

wardawgmalvicious/claude-config

Use for Microsoft Fabric Eventhouse / KQL Database. Covers connection (cluster URI via `kqlDatabases` REST, kusto.kusto.windows.net audience, az rest temp-file for `|` escaping), authoring (`.create-merge` for safe schema evolution, ingestion inline/set-or-append/from-storage `;impersonate`, streaming policy, CSV/JSON mappings, retention/caching/partitioning/merge policies, materialized views + update policies, external tables), OneLake-availability-ON constraints (add/delete column ✅ April 2026+; type/rename/RLS/deletes need availability off), per-KQL-database remote MCP server (http, read/query auth, not in global MCP template), 4-role permissions (viewer/user/ingestor/admin), KQL query patterns (time-filter-first, has vs contains, materialize), string-matching speed table, KQL graph operators (`make-graph`/`graph-match`/`graph()` snapshots, openCypher — in-engine KQL graph, NOT the GraphModel item; see fabric-graph), and Fabric gotchas (`;impersonate`, MV stuck at 0%, dynamic vs string, == case-sensitive).

2026-07-082

fabric-data-agent

wardawgmalvicious/claude-config

Use when configuring Microsoft Fabric Data Agents (GA March 2026) — conversational Q&A built on Azure OpenAI Assistant APIs over Lakehouse / Warehouse / KQL / Semantic Model / Fabric SQL DB / Mirrored DB / Ontology / Microsoft Graph (≤5 sources per agent). Covers the four configuration layers (agent instructions, data source instructions, descriptions for routing, example queries ≤100/source), when to use vs semantic-model AI instructions, the governance precedence chain (organizational → role-based → developer → user intent), best practices (right-layer scoping, iterate on real questions, version control), and key limitations (read-only, structured data only, English only, 25-row/25-column response cap, no example queries on semantic model sources). The Creator Agent ('Build agent with AI', SQL/Eventhouse only), M365 Copilot Agent Store + Copilot-in-Power-BI, Python SDK, Copilot Studio, Azure AI Foundry / Agent Service, and service-principal auth (not Foundry/Copilot or KQL) all remain in preview.

2026-07-022

fabric-monitoring

wardawgmalvicious/claude-config

Use for monitoring Fabric Warehouse queries — OPTION (LABEL = '...') for tracking, the queryinsights schema (exec_requests_history, exec_sessions_history, long_running_queries, frequently_run_queries), 30-day retention, 15-minute appearance lag, the `Invalid object name` gotcha on newly-created warehouses, and diagnosing slow/stale Lakehouse SQLEP reads under the new metadata-sync preview (`sys.dm_db_external_tables_log_status`, `sp_dw_refresh_ext_table`).

2026-07-022

pbid-tom-live

wardawgmalvicious/claude-config

Use for scripting an open Power BI Desktop model via its localhost msmdsrv.exe Analysis Services proxy — TOM (Microsoft.AnalysisServices.Tabular) for metadata, ADOMD.NET (AdomdConnection) for DAX. Covers PowerShell setup with retail.amd64 AMO/TOM + ADOMD NuGet DLLs, discovering the msmdsrv port (msmdsrv.port.txt / netstat), connecting via server Databases Model, SaveChanges / UndoLocalChanges, ExecuteReader for EVALUATE, DAX validation pre-save, TMSL refresh types (full / calculate / automatic / dataOnly / clearValues / defragment), VertiPaq DMVs ($SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS, TMSCHEMA_*), query listener via DISCOVER_SESSIONS, EVALUATEANDLOG trace events (DAXEvaluationLog), FE-vs-SE Server Timings profiling, DAXLib UDF packages (CL 1702+), Calendar Column Groups (CL 1604+). Invoke when user mentions TOM, ADOMD, msmdsrv, VertiPaq, DMV, EVALUATEANDLOG, Server Timings, daxlib.

2026-07-022

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)
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

fabric-database

Fabric SQL Database

Key Differences from Fabric Warehouse

Fabric-Specific Context

Reference

See also

Fabric SQL Database

Key Differences from Fabric Warehouse

Fabric-Specific Context

Reference

See also

fabric-database

Fabric SQL Database

Key Differences from Fabric Warehouse

Fabric-Specific Context

Reference

See also

More from this repository

More from this repository

Fabric SQL Database

Key Differences from Fabric Warehouse

Fabric-Specific Context

Reference

See also