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
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
Preset
Quickly build and share beautiful, customized, and dynamic dashboards that showcase your data with just a few clicks. Easily explore with our no-code viz builder or run deeper analysis using our state-of-the-art SQL editor. Leverage the investments you have made in your data infrastructure with a lightweight and powerful visualization layer on top. Superset is agnostic to your underlying data architecture and doesn't require an additional ingestion layer. Apache Superset is a powerful open source data visualization tool built out of Airbnb. Founded by the original creator of Superset, Preset delivers a complete, easy to consume, enterprise ready platform for Superset.
Learn more
RazorSQL
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more. Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more. Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.
Learn more