Altova DatabaseSpy
The DatabaseSpy SQL editor features customizable SQL auto-completion to accelerate SQL query development. Execute queries and see immediate results in one or more windows that may be tabbed or stacked. DatabaseSpy supports asynchronous query execution, allowing multiple SQL queries to be processed in different windows at the same time, either queries to different servers or even multiple queries against the same server. DatabaseSpy includes support for SQL queries that contain parameters, also known as SQL Templates. Parameters can make a query much more flexible, for instance allowing users to easily test complex join statements with multiple values. The DatabaseSpy SQL Editor and result windows at the top left below show a query to report all orders of a specific product by a specific customer.
Learn more
Text2SQL.AI
Generate SQL with AI in seconds. Turn your thoughts into complex SQL queries using natural language.
Text2SQL.AI uses theOpenAI GPT-3 Codexmodel which can translate English prompts to SQL queries, and SQL queries to English text. It is currently the most advanced Natural Language Processing tool available, and this is the exact same model which used by Github Copilot.
The app currently supports:
SQL generation from English textual instructions. Supports SELECT, UPDATE, DELETE queries, CREATE and ALTER TABLE requests, constraints, window functions, and literally everything!
SQL query explanation to plain English
Your custom database schema (tables, fields, types) connection (with history)
SQL dialects for MySQL, PostgreSQL, Snowflake, BigQuery, MS SQL Server...
If you have any other feature request, please let us know.
Learn more
PopSQL
PopSQL is a collaborative SQL editor and workspace that connects everyone in the data analysis process so that teams can obtain better data insights and visualizations by asking the right questions, together.
* Get answers faster with real-time collaboration, version history, searchable shared queries and folders. We make it easy for your power SQL users and data analysts to work with business stakeholders
* Built-in data visualization & sharing lets you go from query to chart to Slack in seconds. Build, schedule and push real-time insights and dashboards, in just a few clicks.
* Our modern and elegant cloud-based workspace offers a rich SQL editing experience. Dive right in, connect to your databases and iterate on analyses from anywhere. We offer native macOS, Windows, and Linux clients.
* One workspace to get it done: PopSQL puts your database connections, shared credentials and an intuitive data catalog at your fingertips so you can access & mine your data, safely, securely
Learn more
QStudio
QStudio is a free, modern SQL editor supporting over 30 databases, including MySQL, PostgreSQL, and DuckDB. It offers features such as server browsing for easy viewing of tables, variables, functions, and configuration settings; SQL syntax highlighting; code completion; the ability to query servers directly from the editor; and built-in charts for data visualization. QStudio runs on Windows, Mac, and Linux, providing particularly good support for kdb+, Parquet, PRQL, and DuckDB. Additional functionalities include data pivoting similar to Excel, exporting data to Excel or CSV, and AI-powered tools like Text2SQL for generating queries from plain English, Explain-My-Query for code walkthroughs, and Explain-My-Error for debugging assistance. Simply send the query you want and select the chart type to draw a chart. Send queries straight from within the editor to any of your servers. All data structures are handled perfectly.
Learn more
