SQL Server banner
← All connectors

Explore SQL Server with Azimutt

Tables Relations Statistics Query history Triggers Procedures Query data

SQL Server is a powerful, enterprise-level relational database developed by Microsoft, used for handling large-scale business applications and data analytics. Known for its seamless integration with other Microsoft tools, such as Azure, Excel, and Power BI, SQL Server provides a robust solution for both transactional processing and business intelligence. It offers high availability, built-in security features, and advanced analytics capabilities.

Azimutt is making the first database explorer targeted for real world databases: large, heterogeneous and messy 😅 If you ever looked for an Entity-Relationship diagram tool (ERD) or drew your database schema on a sheet or whiteboard, Azimutt is made for you. But it goes well beyond that with database documentation, cross-database data exploration and even linter and monitoring of your database.

You can access the SQL Server connector on GitHub, have a look and even suggest improvements.
The most interesting part is the getSchema function in src/sqlserver.ts that fetch the SQL Server schema and make it accessible to Azimutt.

Moreover, it also infers JSON column schema when found columns with JSON inside.

How to use it #

The SQL Server connector is already included in the Gateway, you can use it simply by:

  • Launching the Gateway, if needed (for the local one use npx azimutt@latest gateway)
  • Create a new project or add a source to an existing one
  • Fill your SQL Server database url (ex: sqlserver://user:pass@localhost:1433/your_db or Server=localhost,1433;User Id=user;Password=pass;Database=your_db)
Azimutt create project

Here are more details about how Azimutt secure your data and especially your database url.

If you don't have a SQL Server database available, you can create one with Docker:

docker run --name mssql_sample -p 1433:1433 -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD=azimutt_42 -e MSSQL_PID=Evaluation mcr.microsoft.com/mssql/server:2022-latest

And use this sample script to populate it.

Here is what you can do with Azimutt: Azimutt diagram

Other connectors you may want to check:

MariaDB logo

MariaDB

An open-source fork of MySQL with improved performance, scalability, and open development. Also available to connect to Azimutt.

MongoDB logo

MongoDB

A NoSQL database designed for flexible, document-oriented storage and scalability. Collection schema and relations are inferred in Azimutt.

PostgreSQL logo

PostgreSQL

The most powerful open-source relational database, known for extensibility and SQL compliance. Now explorable with Azimutt.

Snowflake logo

Snowflake

A cloud-native data platform for seamless data warehousing, sharing, and analytics. Easily explorable with this Azimutt connector.