Please enter your information to subscribe to the Microsoft Fabric Blog.

Thanks for subscribing to the Microsoft Fabric Blog. You’ll receive email notifications when we publish new posts.

Microsoft Fabric Updates Blog

  1. Updates
  2. Fabric Platform

How to create a SQL database in Fabric using Fabric CLI

Step into the future of simplicity with Fabric CLI. The Fabric Command Line Interface (CLI) has arrived in preview, bringing with it a seamless way to create SQL databases for your projects. This guide will take you through the steps to get started, ensuring you can leverage the power of Fabric CLI with ease.

Prerequisites

Before you begin, ensure you have the following in place:

  • Make sure Python version 3.10,3.11 or 3.12 is installed on your machine as well as python is accessible from your terminal (path environment variable).
  • Install Fabric CLI on your machine with the command below.
    • pip install ms-fabric-cli
  • You have access to a Microsoft Fabric workspace.
  • A valid Microsoft account with permissions to create databases.

Steps

Step 1: Log in to Microsoft Fabric

Open command prompt and run the command below.

fab auth login

Note: for this article I chose “Interactive with a web browser” option.

Follow the prompts to authenticate using your Microsoft account.

Step 2: Create a New SQL database

Run the command below to create a SQL database:

fab create <workspacename>.Workspace/<databasename>.SQLDatabase

Note: replace <workspacename> with the name of the workspace where you want to create the SQL database and replace <databasename> with the name that you want to use for your SQL database workload

Step 3: Verify Database Creation

To ensure that SQL database is created successfully in your workspace run below command

fab ls <workspacename>.Workspace

This will display a list of all artifacts that are in the workspace including the one that just got created. Ensure that your newly created database is in the list.

Next Steps

Fabric CLI is currently available in preview, offering users an efficient means to interact with fabric as a file system. This tool enhances automation and streamlines processes such as CI/CD pipelines, thereby facilitating faster and more simplified workflows.

To learn more about fabric CLI on the Fabric CLI GitHub page

Related blog posts

How to create a SQL database in Fabric using Fabric CLI

Blog's featured image

Introducing new item creation experience in Fabric
June 17, 2025 by Dan Liu

Have you ever found yourself frustrated by inconsistent item creation? Maybe you’ve struggled to select the right workspace or folder when creating a new item or ended up with a cluttered workspace due to accidental item creation. We hear you—and we’re excited to introduce the new item creation experience in Fabric! This update is designed … Continue reading “Introducing new item creation experience in Fabric”

Read more
Blog's featured image

Creating SQL database workload in Fabric with Terraform: A Step-by-Step Guide (Preview)
May 28, 2025 by Sukhwant kaur

Infrastructure as Code (IaC) tools like Terraform have revolutionized the way developers and organizations deploy and manage infrastructure. With its declarative language and ability to automate provisioning, Terraform reduces human error, ensures consistency, and speeds up deployment across cloud and on-premises environments. In this document, we’ll explore how you can create SQL databases workloads in … Continue reading “Creating SQL database workload in Fabric with Terraform: A Step-by-Step Guide (Preview)”

Read more