DB TEAM

A professional SQL Server IDE for Windows — modular, bilingual (EN/FR), themeable.
Query, compare, design, profile, generate, document — all in one installable app.

.NET 8 Windows Release MIT License CI CodeQL

Features

Twelve modules, one shell — everything you need to work with SQL Server.

🗄️

Connection Manager

Windows / SQL / Azure AD auth. Credentials encrypted with DPAPI. Test, save, multi-connection.

🌳

Object Explorer

Lazy-loaded hierarchical tree. Icons per object type. Right-click scripting + disconnect.

▶️

Query Editor

AvalonEdit · T-SQL syntax · autocomplete (keywords + tables + views + procs + functions + columns) · format on Ctrl+K · execute on F5.

⚖️

Schema Compare

Diff tables, views, procedures, functions across databases. Column-level ALTER generation wrapped in a transaction.

📋

Data Compare

Row-level diff by primary key. Produces INSERT / UPDATE / DELETE merge script.

🏗️

Table Designer

Visual editor for columns, types, nullability, identity, PK, defaults. Create or load existing tables.

📈

Query Profiler

Estimated + actual plan. Hierarchical plan tree with icons per physical operator and per-node stats.

🎲

Data Generator

Bogus-powered fake data. Column-name heuristics: email, phone, name, city, company, etc. Preview → insert.

📄

Documenter

One-click HTML documentation of a database: tables, columns, indexes, FKs, views, procedures, functions.

🗺️

ER Diagram

Interactive canvas. Drag tables to rearrange, Ctrl+wheel to zoom, export as PNG.

🕑

Query History & Favorites

Every run recorded. Filter, star favorites, double-click to reopen in a new tab.

📤

Export Results

CSV (RFC 4180, UTF-8 BOM) · Excel (header + filter + frozen row) · JSON · XML. One click from the editor toolbar.

🛡️

Administration

Logins · users · roles · permissions · index fragmentation with REORGANIZE/REBUILD recommendations · slow queries · active sessions · BACKUP / RESTORE script generators.

🐞

T-SQL Debugger

Statement-level stepping on a persistent connection so DECLARE / SET / transactions survive between steps. Breakpoints, step over, continue, session state inspection.

Terminal

Embedded PowerShell / cmd / claude / gh / sqlcmd / any CLI inside a document tab. Quick snippets sidebar.

🤖

AI Assistant

Bring your own key — Anthropic · OpenAI · Azure OpenAI · Ollama. Chat, quick SQL prompts, DPAPI-encrypted key storage.

Keyboard shortcuts

The essentials.

F5 — Execute query
Ctrl + K — Format SQL
Ctrl + Space — Autocomplete
Ctrl + N — New connection
Ctrl + Q — New query
Ctrl + wheel — Zoom diagram

Module status — v2.1.0

Roadmap complete. 21 modules shipped across 13 tagged releases. Conditional breakpoints and full i18n polish landed in v2.1.

Connection Manager
v1.0
Object Explorer
v1.0
Query Editor + autocomplete + format
v1.0
Schema Compare + column-level ALTER
v1.2
Data Compare + PK merge + CHECKSUM
v1.7
Table Designer (create + edit)
v1.3
Query Profiler (tree + graph + stats)
v1.9
Data Generator (Bogus)
v1.0
Documenter (HTML)
v1.0
ER Diagram (drag, zoom, PNG)
v1.2
Query History + favorites
v1.1
Results export (CSV/Excel/JSON/XML)
v1.5
Session restore
v1.3
Accessibility baseline
v1.3
Theme Light / Dark / System
v1.0
Localization EN / FR
v1.0
Installer (.exe, portable zip)
v1.2
Snippets · F12 · real-time validation
v1.5
Administration panel
v1.5
Embedded Terminal
v1.5
AI Assistant (BYO-key)
v1.6
Monitoring (live DMV)
v1.7
Import CSV
v1.7
Query Builder visual
v1.7
Git integration
v1.7
Schema snapshot
v1.7
MSIX + winget manifests
v1.8
Code signing workflow + self-signed scripts
v1.8
LocalDB integration tests
v1.8
IntelliSense alias resolution
v1.9
Profiler graphical plan
v1.9
Master-detail · Pivot · per-tab DB
v1.9
T-SQL Debugger (statement-level + step-into)
v2.0
Function signatures in autocomplete
v2.0
Conditional breakpoints (T-SQL expression)
v2.1
Live language switch (status bar, tab titles)
v2.1
Auto-update (Velopack)
scaffold — awaiting signed releases
Automated screenshots (FlaUI)
scaffold — awaiting visuals

Built with

Modern stack, open-source libraries, clean MVVM architecture.

.NET 8 WPF AvalonDock AvalonEdit ModernWpfUI Material Design Icons CommunityToolkit.Mvvm Microsoft.Data.SqlClient ScriptDom SMO Bogus Dapper EPPlus Serilog xUnit Inno Setup GitHub Actions Dependabot CodeQL

Documentation

Get started

Self-contained Windows x64 binary. No .NET install. Per-user install, clean uninstall.