How to Connect Metabase with MSSQL Server Express Edition

Metabase: is the easy, open-source way for everyone in your company to ask questions, learn from data & get business intelligence and analytics to everyone in your company

GitHub - metabase/metabase: The simplest, fastest way to get business intelligence and analytics to…

Metabase | Business Intelligence, Dashboards, and Data Visualization

SQL Server 2022 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Here is how to Connect Metabase with MSSQL Server Express Edition

Step 01: Click on admin settings

Step 02: Click on add a database

Step 03: Enter Database Type as MSSQL Server

Step 04: Enter Display name

Step 05: Enter Host as Localhost.

Step 06: Enter port as 1433

Step 07: Enter Database name

Step 08: Enter user name for database

Step 09: Enter password for Database

Step 10: Click on save.

Step 10: Now click on exit admin.

Step 11: Click on table to view data

Step 12: Now it will show quick look of table

Here is Youtube video for quick visual reference.

Other Metabase Articles.

Metabase: Create Stacked Bar Chart-Visual SQL Query-Automated Insights-Add to Dashboard.

How to Connect Metabase with YugabyteDB

How to Connect Metabase with MindsDB (Build AI with SQL)