skills.rest
9vantage
9vantageCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sqldb-authoring-cli

Create and manage SQL databases in Microsoft Fabric using sqlcmd, SqlPackage, and az CLI.

Updated Jul 14, 2026
Search Tags:#sqlcmd#dacpac#sqlpackage#t-sql#microsoft fabric#sql database#schema deployment
One-click install
npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill sqldb-authoring-cli-9vantage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldb-authoring-cli
Source: https://github.com/9vantage/skills-for-fabric-clone/tree/main/plugins/fabric-authoring/skills/sqldb-authoring-cli
Command: npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill sqldb-authoring-cli-9vantage

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Authoring and deploying SQL database schemas in Microsoft Fabric requires coordinating multiple CLI tools, Entra ID authentication, endpoint discovery, and platform-specific limitations, which is error-prone without structured guidance. ## Core Features & Use Cases - T-SQL DDL/DML Authoring: Create tables with constraints, foreign keys, triggers, indexes, temporal tables, and vector columns using the Go-based sqlcmd tool. - Schema Deployment: Deploy and evolve schemas with SqlPackage (.dacpac/.bacpac), configure source control, CI/CD pipelines, and GraphQL APIs. - Use Case: A data engineer needs to create a new SQL database in Fabric with enforced primary keys and temporal audit tables, then set up repeatable deployments. The skill guides endpoint discovery via az rest, schema authoring via sqlcmd, and extraction of a .dacpac for CI/CD. ## Quick Start Ask the AI to create a SQL database in Fabric and author a table with primary keys and foreign key constraints using sqlcmd.

Frequently Asked Questions about sqldb-authoring-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a SQL database in Microsoft Fabric from the CLI?▼

Create a SQL database in Fabric using az rest against the Fabric REST API after verifying the workspace has a capacityId. Specify the collation at creation time since it cannot be changed afterward, then discover the TDS endpoint via REST for sqlcmd connections.

How do I deploy schema changes to a Fabric SQL database?▼

Use SqlPackage to extract a .dacpac from the database and publish it for incremental schema changes. Use Authentication=Active Directory Default in the connection string, since SQL authentication is not supported on Fabric.

Does SQL database in Fabric support foreign keys and constraints?▼

Yes, SQL database in Fabric fully supports enforced constraints including primary keys, foreign keys, CHECK, and DEFAULT constraints, unlike Fabric Data Warehouse. It also supports temporal tables, triggers, and stored procedures.

Why does sqlcmd login fail against a Fabric SQL database?▼

Login failures usually come from a mismatched -d database name (case-sensitive), an expired az login session for ActiveDirectoryDefault, or a stale FQDN. Re-discover the endpoint via the REST API and refresh Azure CLI authentication.

What are the limitations of SQL database in Fabric?▼

Unsupported features include CDC, Always Encrypted, in-memory OLTP, ledger, CTAS, COPY INTO, and SQL authentication. Tables with vector or json columns cannot be mirrored to OneLake, and resource limits include 32 vCores, 4 TB storage, and 150 databases per workspace.

Related Skills

Explore More Software Engineering Skills→
jgezelscorpjgezelscorp

entra-app-registration

Automate Microsoft Entra ID app registration, authentication, API permissions, and client credentials.

Community
Advanced
PatrickGallucciPatrickGallucci
16

fabric-pbi-perf-remediate

Diagnose and remediate Power BI performance issues in Fabric environments.

Community
Advanced
weiflycc-cmdweiflycc-cmd

sqldw-consumption-cli

Execute read-only T-SQL queries against Microsoft Fabric SQL endpoints via CLI.

Community
Intermediate
weiflycc-cmdweiflycc-cmd

spark-consumption-cli

Run interactive PySpark and Spark SQL analytics on Microsoft Fabric lakehouse data via the Lakehouse Livy API.

Community
Intermediate