Microsoft SQL Server client

The SQL Server client with the highest user satisfaction.

Microsoft SQL Server client
Microsoft SQL Server client
DbVisualizer has helped users manage their Microsoft SQL databases for decades.
Microsoft SQL Server G2 badge
Microsoft SQL Server client

A SQL Server client you can trust

With support for Microsoft SQL Server-specific object types, you’ll find all the tools you need to develop, connect and manage your Microsoft SQL Server database.

Object type support for MSSQL Server

Object types

MSSQL Server supports multiple different object types. There are common object types, like Schemas and Tables. Other object types are unique, such as Sequences, LinkedServers and HistoryTables. In DbVisualizer, you’ll easily find and manage all objects in your database, just as intended by Microsoft SQL Server

Object type actions

Each object type is meant to be used in a particular way. As a powerful Microsoft SQL Server Client, DbVisualizer supports the unique actions of the object types in MSSQL. You can perform the actions via simple SQL queries or even right-click on the object and select the preferred action.

Learn more about what object types are supported for MSSQL Server.

Microsoft SQL Server object types

An SQL editor built for SQL Server

Auto-complete

Writing SQL for MSSQL Server is subtly different from writing it for other databases. DbVisualizer understands these differences and will make relevant suggestions so that you can create SQL queries more efficiently.

SQL formatting

Insert unformatted SQL queries straight into DbVisualizer, and automatically get it formatted for easy editing in the SQL Server client.

Variables

You might need to execute a query several times, only changing small details. With client-side variables for SQL Server the user will be prompted to insert only these specific values, removing the need for any edits to the query itself. A real time saver.

Learn more about the supported features for MSSQL Server.

Microsoft SQL Server autocomplete

See the relationship in your MSSQL Server databases.

Automatic Entity relationship diagrams (ERDs)

The relationships in SQL Server are crucial to understand. With automatically generated ERDs you can visually see all dependencies and opportunities directly in the Microsoft SQL Server client.

ERD Microsoft SQL Server
See the ERD feature
Microsoft SQL Server ERD illustration

Explain plans

See the explain plan for your request to understand how it is handled by the database. You can find ways to optimize the query to make sure your queries are efficiently executed by the server.

Microsoft SQL Server ERD illustration
Postgresql scheduling pgagent

Scheduling with SQL Server Agent

DbVisualizer supports the use of SQL Server Agent for scheduling of tasks.

Jobs can also be automatically scheduled outside of the MSSQL Server client, using the command-line interfacecommand-line interface and the pre-built scheduling tools of your OS.

Try DbVisualizer Pro

Start your free 21 day evaluation of DbVisualizer Pro
Maven Microsoft SQL Server driver

SQL Server JDBC driver management

DbVisualizer always has the latest JDBC driver for Microsoft SQL Server, and historical versions. With the JDBC driver manager you’ll easily connect to your databases using JDBC drivers hosted on Maven, with multiple versions to choose from.

Learn more and download SQL Server JDBC driver

Maven Microsoft SQL Server driver
Microsoft SQL Server driver manager

Properties for Microsoft SQL Server

You can set up custom properties for your MSSQL databases directly in DbVisualizer, so that you can make it the best Microsoft SQL client matching your preferences. Make sure the user is propted to enter User ID and password. Enable preprocessing of scripts. You can even set up auto-commit and much more. Configure the client to work as you want directly in the Microsoft SQL Server manager.

Microsoft SQL Server properties

Users love using DBVisualizer with Microsoft SQL Server.

  • Tim S
    Teamlead of Back-end Golang command

    I love the fact that DbVisualizer works with all the database systems that I have databases in. It makes life VERY easy for me to go back and forth from MS SQL Server to MariaDB to PostgreSQL to MySQL. AND, I also have options if I have to work with others too!
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Anonymous
    Education Management

    I use it for MSSQL, MySQL, Pg and sometime sqlite. Its great to have the same tool for all those different database engines. I really like that i can ssh tunnel into my servers and then connect to the database. Its cross-platform support is very nice, my co worker uses windows and i use linux so being able to use the same software helps us.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Michael L
    Owner, Director of Managed Services

    If you dig into Oracle, Postgres, SQL Server, DB2, MySQL and other databases regurarly, this tool is for you!
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Leonardo D
    CTO & Senior Software Engineer

    What I like best about DBVisualizer is how easy it is to navigate the data through entities (tables) and display a graphic representation of the relations. I haven't seen this feature in any other DB admin software.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Elisabeth J
    Business Analyst

    I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are easy to set up and I really like being able to set the color for different connections - to provide a visual cue as to which environment I am working in (production vs test). DB Visualizer has lots of features that I haven't used but would like to explore. I like that DBVis is continually making improvements to the software.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Tim S
    Teamlead of Back-end Golang command

    I love the fact that DbVisualizer works with all the database systems that I have databases in. It makes life VERY easy for me to go back and forth from MS SQL Server to MariaDB to PostgreSQL to MySQL. AND, I also have options if I have to work with others too!
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Anonymous
    Education Management

    I use it for MSSQL, MySQL, Pg and sometime sqlite. Its great to have the same tool for all those different database engines. I really like that i can ssh tunnel into my servers and then connect to the database. Its cross-platform support is very nice, my co worker uses windows and i use linux so being able to use the same software helps us.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Michael L
    Owner, Director of Managed Services

    If you dig into Oracle, Postgres, SQL Server, DB2, MySQL and other databases regurarly, this tool is for you!
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Leonardo D
    CTO & Senior Software Engineer

    What I like best about DBVisualizer is how easy it is to navigate the data through entities (tables) and display a graphic representation of the relations. I haven't seen this feature in any other DB admin software.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
  • Elisabeth J
    Business Analyst

    I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are easy to set up and I really like being able to set the color for different connections - to provide a visual cue as to which environment I am working in (production vs test). DB Visualizer has lots of features that I haven't used but would like to explore. I like that DBVis is continually making improvements to the software.
    Verified DbVisualizer user.
    Review from G2.
    g2 review
/* g2 reviews */

Great feedback from great users.

DbVisualizer is a G2 Leader among database management software.

Frequently asked questions


  • What is MSSQL?

    Microsoft SQL Server is a relational database management system.

  • What is a MSSQL client?

    You use the MSSQL client to connect to your MSSQL database once connected you can manage your data.

  • What is MSSQL database client used for?

    The client is used to navigate and manage data in your Microsoft SQL Server database.

  • How do I connect to MSSQL with DbVisualizer?

    It is very easy to connect to your Microsoft Server database via the built-in driver manager in DbVisualizer. The driver manager is hosted on Maven and gives you multiple versions of JDBC drivers to choose from.

  • How can I use DbVisualizer as a query tool?

    You write your SQL queries in DbVisualizer that cleverly highlights operations and autocomplete suggestions. The tool also has a visual query builder, that automatically generates SQL code as you drag and drop tables and select what values you want to include.

/* NOTIFICATION */

Download starting...

Please hold on while we prepare your download. You can close this dialogue and continue browsing our site while you wait.

GOT IT →