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
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 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
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
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.

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
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
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
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

dbForge Query Builder killer feature - Query Plan

  • View the EXPLAIN plan and profiling results, and monitor session statistics
  • Save time on detecting bottlenecks in your queries
  • View time delays at different stages of executing a query
  • Compare differences in query profiling results visually
  • Get a clear and automated way to profile your database queries
  • Fetch SQL query data faster
  • Trace SQL queries and diagnose performance issues with slow queries
Download free trial Learn more

Check out our quick video guides

  • Design UPDATE Query
  • Design INSERT Query
  • Design DELETE Query
  • Manipulate SQL Data
  • View SQL Data

Design 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 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 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 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 explore a detailed and interactive visual representation of how SQL JOINs work in different scenarios using Query Builder. The tool clearly illustrates each join type for better comprehension.

Try it now Learn more

dbForge SQL Tools

Enhance SSMS with essential add-ins and tools, including Query Builder, and boost all database-related tasks
SAVE UP
TO $2309

Leading companies
choose dbForge Query Builder

Hanesbrands
Arconic
Gap
Nationwide
Alcoa

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.

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.

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!

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

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.