GXP SQL Designer

GXP SQL Designer is a Microsoft Windows desktop application for designing, generating, validating and
executing SQL queries through a visual designer.

Features

• Schema reading for tables, views, columns, primary keys, indexes and relationships.
• Visual designer with resizable tables, editable joins and a field grid.
• Provider-specific SQL generation, including TOP, LIMIT, delimiters and schema names.
• SQL editor with syntax highlighting, optional automatic formatting and field autocomplete.
• Import of existing SELECT queries to rebuild tables, joins, fields, WHERE, GROUP BY, HAVING and ORDER BY.
• Query execution with results that can be viewed, copied, exported and, when possible, edited.
• Creation of databases, tables, indexes, views and columns from the interface.
• Data import and export between databases, using bulk copy when importing into SQL Server.
• Preventive confirmation of affected rows before UPDATE or DELETE commands are executed.
• Integrated most popular SQL functions
• Available in English and Italian languages (

Supported Databases

Microsoft SQL Server (2008R2 and later)
Microsoft Access
MySQL
PostgreSQL
SQLite
ODBC Available for generic drivers.

Requirements and Installation

• Microsoft Windows 10 or Windows 11.
• Microsoft .NET Framework 4.8 installed (or activated) on the computer.

Download Trial (30 days)

• Download Trial (32 bit)
• Download Trial (64 bit)

Help Documentation Page

• User Guide (English)
• User Guide (Italian)