SQL Server

Connections, schema browsing, and queries.

Ready

The SQL Server driver connects with SQL or Windows authentication and browses schemas, tables, views, functions, procedures, and triggers. Showplans open as a visual EXPLAIN graph; a table designer for SQL Server is planned.

Capabilities

Connections

Ready

Host, port, database, and credentials, or Windows authentication.

Schema browser

Ready

Schemas, tables, views, functions, procedures, triggers, sequences, and alias types.

SQL editor and results

Ready

Schema-aware completion and the native result grid.

Create forms

Ready

Create schemas, tables, views, functions, procedures, and triggers.

Visual EXPLAIN

Ready

SHOWPLAN rendered as a graph, with estimated rows and cost on every operator.

Table designer

Planned

SQL Server dialect support for the table designer.

In the app

ZQLZ grid of a SQL Server table with uniqueidentifier, money, bit and JSON columns beside the column list — SQL Server types, from uniqueidentifier and money to datetimeoffset and a persisted computed column.

ZQLZ grid of a SQL Server view opened like a table, with its CREATE VIEW action — A view opens like a table, with its CREATE VIEW one click away.

ZQLZ editor with a T-SQL query that reads a JSON value from a column and groups on it — T-SQL that reads a JSON value out of a column and groups on it.

ZQLZ visual explain for a SQL Server showplan with estimated rows and subtree cost per operator — A showplan as a graph, with estimated rows and cost on every operator.

ZQLZ grid of a SQL Server orders table with foreign key markers, and its columns and indexes in the side panel — A table opens with its foreign keys marked, and its columns and indexes alongside.

ZQLZ grid of a SQL Server table named select in its own schema with keyword and emoji column names — A table named select in its own schema, with keyword and emoji column names.

Connecting

Host, port (1433), database, user, and password, or Windows authentication, with an option to trust the server certificate.

← All databases

SQL Server

Connections, schema browsing, and queries.

Download ZQLZ View roadmap

Ready

Capabilities

Connections

Ready

Host, port, database, and credentials, or Windows authentication.

Schema browser

Ready

Schemas, tables, views, functions, procedures, triggers, sequences, and alias types.

SQL editor and results

Ready

Schema-aware completion and the native result grid.

Create forms

Ready

Create schemas, tables, views, functions, procedures, and triggers.

Visual EXPLAIN

Ready

SHOWPLAN rendered as a graph, with estimated rows and cost on every operator.

Table designer

Planned

SQL Server dialect support for the table designer.

In the app

Connecting

Host, port (1433), database, user, and password, or Windows authentication, with an option to trust the server certificate.

← All databases