Querying Data
Use SQL to read, insert, update, and delete data in your Datasquirel databases.Overview
Datasquirel is built on MariaDB, so all standard SQL query syntax works as expected. You can run queries directly from the admin panel SQL shell or through the REST API.
SELECT
Retrieve data from one or more tables.INSERT
Add new rows to a table.UPDATE
Modify existing rows in a table.DELETE
Remove rows from a table.Running Queries
You have two options for executing SQL queries:
Admin Panel SQL Shell — navigate to any database in the admin panel and open the SQL shell. Type your query and run it. Results appear in a table below the editor.
REST API — POST any SQL string to the /api/v1/sql endpoint and receive results as JSON. See API Reference → SQL.