PrimalSQLPrimalSQL

SAPIEN TechnologiesQuery Editors
Version 2026 (4.5.x) (Jul 30, 2026)

Develop and test queries across multiple databases with ease.

  • Supports diverse databases including SQL Server, Oracle, MySQL, and Access.
  • Build complex queries visually or edit SQL text directly.
  • Export results and generate scripts in PowerShell, VBScript, and more.
SAPIEN Technologies logo

Prices from:

Loading...
Available individuallyOur Price
PrimalSQLLoading
Also available in
SAPIEN DevOps SuiteLoading
Need help choosing? See How to Buy

Trial version available Contact us for a free trial

Makes database query development and testing a snap.
PrimalSQL is a versatile database query development component that supports connections to a wide range of database vendors, enabling IT professionals to build, test, and refine SQL queries from a unified environment. It facilitates complex query creation through a visual builder or direct text editing and offers capabilities to export results and generate scripts for automation and development needs.

Supports multiple database providers

Connect simultaneously to various database types such as Microsoft SQL Server, Oracle, MySQL, Microsoft Access, and others through ODBC and OLEDB with a single interface for universal database access.

Visual Query Builder

Create complex SQL queries without advanced SQL knowledge using the drag-and-drop Visual Query Builder, enabling users to build queries visually and then refine or edit the SQL code directly.

Database Browser

Explore and manage different database connections with a built-in browser that lets users navigate database schemas, tables, views, and stored procedures effectively.

Query editing and live data testing

Write, edit, and execute SQL queries with support for live data editing and testing, providing immediate feedback to optimize query results in real-time.

Stored Procedures and Views Editing

Create and update stored procedures and database views within an intuitive editor, supported by SQL PrimalSense, which aids in writing and debugging SQL code efficiently.

Script generation for automation

Export queries directly as PowerShell or VBScript scripts, including PowerShell graphical user interface (GUI) scripts, to facilitate automation workflows and integration in development environments.

Results export options

Export query results conveniently to multiple formats, including HTML, XML, CSV, and plain text, for easy sharing, reporting, or further data processing.

Multiple simultaneous connections

Open and manage multiple simultaneous database connections across different vendors and types, enabling comprehensive querying and comparison without switching applications.

Formatting of query strings

Format SQL query strings for a variety of languages like PowerShell, VBScript, C++, and HTML to support code reuse and integration in scripts and applications.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Database Support

  • Microsoft Access
  • Microsoft SQL Server
  • MySQL
  • Oracle

Operating System

  • Windows Desktop
  • Windows Server

Windows Desktop Version

  • Windows 11
  • Windows 10

Windows Server Version

  • Windows Server 2025
  • Windows Server 2022
  • Windows Server 2019