This SQL playground allows you to test SQL online.You can test MySQL, Postgresql and SQLite.
It is an SQL editor online, it does not require installation.
/!\ For MySQL and PostgreSQL: The data (tables, index, ...) that you create are deleted after approximately 30 minutes of inactivity.
It is not possible to use transactions (The connection is not persistent).
Typing help / Autocomplete: Ctrl-space for autocomplete.
Enter your SQL query in the editor, finally click on "Run" to execute it. The query result will be displayed below the editor .
You can also run only one query entered in the editor. To do this, simply select it before clicking on "Run".
If you want to export the results in csv format, click on "Export".
The sql queries entered in the editor are saved so that you will find them during your next visits. Warning, this is a local backup in your browser, it can be deleted at any time.
You can share SQL snippet. Click on "Share snippet" to share your SQL code.
Your database will not be backed up, this only saves the editor code! This is useful for sharing SQL code.
You can dump database to file. The format of the dump is different according to the databases:
- MySQL and PostgreSQL: Click on "Database > Dump DB to SQL" to export your database to SQL file.
- SQLite: Click on "Database > Dump DB to sqli file" to export your database to sqli file.
You can choose between the following databases: MySQL, Postgresql and SQLite.In the menu, click on the name of the database you want to use. It may take a few seconds to initialize.
This tool allows you to test SQL queries from different databases without installation. This can be really useful and a time saver when you have to validate queries for a multi-database software.
Another use of this online SQL compiler is to share a snippet. So you can easily share one or more SQL queries. This is useful when exposing a problem on a request on the forums specialized. Thus the requests can be tested easily by your interlocutors.
You can also quickly validate if your query is compatible on different databases. As you must know unfortunately each database deviates more or less from the standard. And some features are not available on all databases.
Once you have performed your SQL queries, you can export all the data from your database (in SQL format or in sqli format for SQLite). Thus, once your data has been generated using this tool, you can import it into your database.You also have the option of exporting data from your "select" queries in CSV format.
Your queries pass through the network, avoid playing with production data. You are advised not to enter passwords, authentication tokens, etc. Although the site works in https, you never know.