Free Online PostgreSQL 17 + PostGIS Playground
Current database engine: PostgreSQL 17 + PostGIS (psql17)
This page runs PostgreSQL 17 (17.10) with the PostGIS 3.6 extension in a clean database. PostgreSQL 17 added JSON_TABLE() to turn JSON into rows and columns, the SQL/JSON query functions JSON_EXISTS(), JSON_QUERY() and JSON_VALUE(), and RETURNING for MERGE.
PostGIS adds spatial types (geometry, geography) and functions such as ST_Distance(), ST_Contains() and ST_Buffer(), so you can test GIS queries right in the browser. Spatial sample data: PostgreSQL 17 PostGIS Workshop.
NEW Now embed mode is available: put an interactive SQL editor on any web page with one script tag.
SQLize is a browser-based PostgreSQL 17 + PostGIS SQL editor and query runner for fast testing, debugging, formatting, and sharing. It is useful for interview tasks, migration checks, analytics validation, and learning SQL in a real execution environment.
Developers, students and data analysts from more than 100 countries, most of all India, the United States, Russia, Brazil, Italy, Poland and Vietnam, use SQLize to run PostgreSQL 17 + PostGIS queries online without installing a database server. A shareable link turns any query into a reproducible example for a colleague, a teacher or a question on Stack Overflow.