SQL Query Builder

dbForge Query Builder for SQL Server is an SQL query builder to make your SQL queries fast and simple regardless of their complexity. Our SQL query tool is a well-polished unit for creating database queries on a whole new interactivity level thanks to the visual features via graphical SQL query designer when dealing with SQL Server through a neat and intuitive UI. Beautify your code and automate workflow using word suggestions and simple visual tips that will complement seamless query management via drag and drop functionality.

SQL statement builder executes created queries and edits tables data
Construct data manipulation queries without manual coding
Auto Join of columns by primary/foreign key or name
Combine a few queries to a sub-query via visual SQL editor
Sort and filter data based on a custom complex criteria
Reverse engineer queries it into a visual representation
Use visual SQL query builder to profile designed queries

Features

Query Builder

The state-of-art diagram with zooming and keyboard support
Preview and printing of the diagram
Visual addition of sub-queries to any part of the main query body
Query outline feature (displayed in Document Outline window)
Visual editing of sub-queries
Expression builder for complex conditions
Graphical SQL query builder provides Undo/Redo support options
Support of visual building of INSERT, UPDATE, and DELETE statements
Quick conversion of SELECT queries into INSERT statements
Handy one-click conversion of SELECT query into UPDATE or DELETE with the saving of WHERE condition

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 searching
SQL formatting on-the-fly in the editor
Executed SQL history window for your selected document
Wizard for batch SQL formatting of files on the connected disk

Query Builder for SQL Server - SQL Editing and Execution

Query Profiler

SHOW PROFILE, EXPLAIN results and STATUS variables displayed in a UI
Plan of the query displayed in the tree view for easy review and evaluation
Profiling history that can be saved for further data analysis
Compare profiling results feature with differences highlight
Profiling results printing
Detailed query information shows which command types were used the most

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 data with column headers
SQL query manager sets up server-side data filters of any complexity
Data Viewer and Editor window for browsing and editing large objects
Foreign key lookup editor, full card view
Full-text (Ctrl+F) and Incremental (Ctrl+I) search through data grid
Grouping by arbitrary columns
Multi-table query result set editing
Paginated data browsing for big results
Visible columns picking dialog box
Editing microseconds in columns with the TIME, DATETIME and TIMESTAMP

Query Builder for SQL Server - Data Editor

Exporting Data

Our SQL query tool supports data export to:

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 allowed
Asynchronous connect to server with ability to cancel the operation
Detailed object properties and data browsing in Object Viewer window
Quick script generation for an object: 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

Building simple, data-aware, and master-detail reports
Exporting to multiple file formats
Automating report building from the command-line interface
Customizing reporting options and appearance of the report
Rearranging and adding new bands to insert different data
Applying search by whole words to the report
Modifying report scaling

Query Builder for SQL Server - Data Reports

Master-Detail Browser

Creating multiple master-detail reports with a simple drag-and-drop feature
Visualizing master-detail relationships between tables
Exporting diagrams to images
Data filtering in the selected tables
Setting a custom filter in master-detail tables
Sorting data in an ascending or descending order
Quickly sending tables to Query Builder
Easily switching between Data and Design Views

Query Builder for SQL Server - Master-Detail Reports

Pivot Table

Quickly creating pivot tables in Pivot Table Designer
Visualizing data relationships with pivot charts
Reordering fields in pivot tables
Sorting and filtering data by predefined conditions
Calculating grand totals using summary functions
Manipulating data with a simple drag-and-drop feature

Query Builder for SQL Server - Pivot Tables

Check out our quick video guides

Design SELECT Query

Make your coding faster and with the dbForge Query Builder for SQL Server tool. Just drag the objects from Database Explorer onto a diagram and enjoy the JOINs created automatically.

Watch video

Design UPDATE Query

In dbForge Query Builder for SQL Server, you can quickly and easily create the SELECT query, preview the selected data, and then convert the SELECT query into the UPDATE statement saving the WHERE condition.

Watch video

Design INSERT Query

Watch the video to learn how you can quickly and seamlessly insert data into tables with the help of the SQL INSERT statement designed with the advanced dbForge Query Builder for SQL Server tool.

Watch video

Design DELETE Query

Watch the video to find out how to create the DELETE Query using the SQL Server Query Builder tool by Devart. With it, you can remove data from SQL Server tables much faster!

Watch video

Manipulate SQL Data

Watch the video to see how to manipulate SQL table data using dbForge Query Builder. The tool allows editing data with the foreign key look up functionality as well as seamlessly inserting, updating, deleting and exporting SQL Server data.

Watch video

View SQL Data

dbForge Query Builder for SQL Server incorporates a sophisticated Data Editor that allows viewing, sorting, grouping, and filtering SQL data right in the results grid. Retrieve and analyze data easily with dbForge Query Builder!

Watch video

SQL Tools for SQL Server

15 essential SSMS add-ins and tools including Query Builder

Get $2869.50 bundle for only $999.95

You save $1869.55

Buy now

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 a FREE 30-day trial and start saving time and effort on your routine query building today!

Download for free

Buy multiple licenses with a substantial discount

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

Purchase now

Try SQL Tools with Query Builder included

Sync schemas, deploy from version control, write SQL, and 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