- Back to Main menu
  
  Back to Products
  Product finder
- Back to Main menu
- Back to Main menu
- Back to Main menu

- Back to Main menu
  
  Shopping Cart
  
  Your cart is currently empty
  
  Add product
Sign in
- de
Contact Sales

Contact Sales

Product finder

Query Builder for SQL Server

Superior query tool for SQL Server that can serve both beginners and professionals

Download

Buy now

SQL Query Builder

dbForge Query Builder for SQL Server is a handy tool that helps you visually construct even the most complex SELECT, INSERT, UPDATE, and DELETE queries with no need for time-consuming manual coding. Simply start drawing your queries on diagrams, and our smart Query Builder will do the rest for you.

Create queries of any complexity on diagrams without manual coding
Auto-join columns by primary/foreign key or name
Add and edit sub-queries
Sort and filter data based on custom criteria
Execute queries and edit table data
Use the integrated Query Profiler to optimize queries
Reverse-engineer queries

Features

Query Builder

Construction of basic and advanced SQL queries
State-of-the-art diagrams with zooming and keyboard support
Diagram preview and printing
Visual addition of sub-queries to any part of the main query
Query outline (displayed in Document Outline window)
Visual editing of sub-queries
Complex conditions expression builder
Graphical SQL query builder with undo/redo options
Quick conversion of SELECT queries into INSERT statements
Conversion of SELECT queries into UPDATE or DELETE with one click

Query Builder for SQL Server - Builder Menu

SQL Editing and Execution

Automatic SQL syntax check
Context-sensitive code completion
Document Outline window for quick navigation through large scripts
Execution of scripts, selected SQL fragments, and statements
Quick information about schema objects
SQL editor with syntax coloring, bookmarks, and text search
On-the-fly SQL formatting in the editor
History of executed SQL queries
Wizard for batch formatting of files on a connected disk

Query Builder for SQL Server - SQL Editing and Execution

Query Profiler

SHOW PROFILE, EXPLAIN results and STATUS variables managed in the UI
Query plans displayed in the tree view for easy examination and evaluation
Profiling history that can be saved for further data analysis
Comparison of profiling results with the highlighting of differences
Printing of profiling results
Detailed query information that shows the most frequently used command types

Query Builder for SQL Server - Query Profiler

Data Editor

Asynchronous data fetch and cancellation
Batch table update mode when changes are accumulated and applied explicitly
Copying of data with column headers
SQL query manager with server-side data filtering and column-hiding features for complex queries
Data Viewer and Editor for browsing and editing large objects
Foreign key lookup editor, full card view
Full-text (Ctrl+F) and Incremental (Ctrl+I) search through the data grid
Grouping by arbitrary columns
Editing of multi-table query result sets
Paginated data browsing for large result sets
Visible column picker
Editing of microseconds in columns with TIME, DATETIME and TIMESTAMP

Query Builder for SQL Server - Data Editor

Exporting Data

Query Builder supports data export to the following formats:

JSON
CSV
XML
Text
XLS
PDF

DBF
HTML
RTF
MDB
ODBC
and SQL

Query Builder also supports exporting data from multiple tables at once and making user Templates.

Query Builder for SQL Server - Data Export

Database Explorer

Multiple database connections
Asynchronous connection to the server with a cancel option
Detailed object properties and data browsing in the Object Viewer window
Quick script generation for objects: SELECT, INSERT, EXECUTE, etc.
'Send To' command for quick sending of tables to Query Builder
Multi-selection for batch operations on numerous data objects
Database navigation history
Drag-and-drop functionality for easy SQL query management

Query Builder for SQL Server - Database Explorer

Data Reports

Easy creation of simple, data-aware, and master-detail reports
Export of SQL data to text files
Automated generation of reports from the command line
Rich customization options
Rearrangement and addition of new bands to insert different data
Search by entire words
Report scaling

Query Builder for SQL Server - Data Reports

Master-Detail Browser

Creation of multiple master-detail reports with a simple drag-and-drop
Visualization of master-detail relationships between tables
Export of diagrams to images
Data filtering in selected tables
Setup of custom filters in master-detail tables
Data sorting in ascending or descending order
Quick sending of tables to Query Builder
Easy switching between Data and Design Views

Query Builder for SQL Server - Master-Detail Reports

Pivot Table

Quick creation of pivot tables in Pivot Table Designer
Visualization of data relationships with pivot charts
Reordering of fields in pivot tables
Data sorting and filtering by predefined conditions
Calculation of grand totals using summary functions
Data manipulations via drag-and-drop

Query Builder for SQL Server - Pivot Tables

Check out our quick video guides

Design a SELECT Query

Make your coding faster and with dbForge Query Builder. Just drag database objects from Database Explorer onto a diagram, and JOINs will be created automatically.

Watch the video

Design an UPDATE Query

With dbForge Query Builder, you can quickly and easily create a SELECT query, preview your selected data, and then convert it into an UPDATE query with the WHERE condition intact.

Watch the video

Design an INSERT Query

Watch the video to learn easy it is to insert data into tables with the help of the SQL INSERT statement designed directly in Query Builder.

Watch the video

Design a DELETE Query

Watch the video to find out how to create a DELETE query in Query Builder. With its help, you can remove data from SQL Server tables much faster!

Watch the video

Manipulate SQL Data

Watch the video to see how to manipulate SQL table data using dbForge Query Builder. You can edit your data with the foreign key lookup as well as seamlessly insert, update, delete, and export data to a multitude of formats.

Watch the video

View SQL Data

Query Builder incorporates a sophisticated Data Editor that allows viewing, sorting, grouping, and filtering SQL data right in the results grid.

Watch the video

See how dbForge Query Builder helps you work with JOINs

SQL JOINs Visualizer

Click the diagram to see the visual illustration of how SQL JOIN operates in different scenarios with the help of the Query Builder. The tool visualizes different joins in the corresponding tab.

Try it now Learn more

Query Builder no selected joins

Leading companies
choose dbForge Query Builder

What people say

Leave a testimonial

You're crazy, damn good support! Thumbs up! If every software company would provide only as half as your speed and customer friendly handling, it would be heaven!

Jens Wichmann

Valenzi GmbH & Co. KG

dbForge Query Builder for SQL Server lets you write query statements within minutes. Great Product... Thank You.

Jerry Schumacher

r&d, Boca Data Solutions

Get started with dbForge Query Builder at no cost

Download Query Builder for a FREE 30-day trial today and see it in action! We're sure that you won't imagine your daily work without it afterwards.

Download for free

Buy multiple licenses with a substantial discount

We provide flexible purchasing options, including bulk discounts, to meet the needs and budget of each and every customer.

Purchase now

Try SQL Tools with Query Builder included

Write SQL, compare and sync databases, integrate version control, and do much more with our mega pack of SQL Server tools!

Find out more

Learn about DevOps Automation

Use dbForge DevOps Automation for SQL Server to extend DevOps practices to SQL Server databases. The solution helps optimizing productivity, reducing database release costs, and making the overall workflow consistent and safe.

Explore

dbForge DevOps Automation for SQL Server