Full SQL Support
Work directly with MariaDB concepts instead of fighting an abstraction layer. Datasquirel lets you design schemas with native SQL types and drop into raw queries whenever the job calls for full control.
How It Works
- Model tables with native MariaDB types — VARCHAR, INT, TEXT, JSON, DATETIME, ENUM, and more
- Configure keys, defaults, and constraintsthrough the schema tools using familiar SQL rules
- Run raw queries when needed from the SQL shell in the admin panel or through the REST API
- Consume results in JSON so custom queries are easy to pipe into applications and internal tools
Key Features
All Standard Data Types
Define tables with the data types you already expect from MariaDB. That keeps the schema understandable to developers and avoids surprises when moving between Datasquirel and direct SQL workflows.Indexes and Constraints
Primary keys, unique constraints, defaults, and indexing stay part of the schema conversation. You can shape data integrity at the database layer rather than depending only on application code.Raw SQL via the REST API
When CRUD endpoints are too limiting, send a raw SQL statement through the API and get the result back as JSON. It is useful for joins, reporting queries, and one-off operations that need exact control.Schema-First Field Design
What you configure is what gets created. Datasquirel maps field settings directly to the underlying table definition instead of translating everything through a custom ORM layer.Use Cases
- Complex queries: Write joins, aggregations, and custom reporting queries when built-in CRUD endpoints are not expressive enough
- Strict schema control: Keep types, defaults, and constraints explicit at the database layer
- Reporting: Return analytical query results as JSON for dashboards, exports, or internal apps
- Advanced MariaDB features: Use window functions, full-text search, and other native SQL capabilities without leaving Datasquirel