@moduletrace/datasquirel is available on NPM
The full-stack data management platform
Datasquirel offers a single platform to manage structured data as well as media storage. Centralizing all your data storage needs in one place.
Everything your data needs, in one place
Leverage the full power of relational databases through a clean GUI admin panel. Datasquirel brings SQL schema design, structured data management, and file storage together — without stitching together separate tools.
Datasquirel is fully compatible with SQL data standards. Define field types, set constraints, build indexes, and manage table schemas — all through a visual interface that maps directly to MariaDB.Data Types Docs
High availability built in
Datasquirel ships with a 3-node MariaDB cluster running Galera replication and MaxScale for load balancing and automatic failover. You get a production-grade, replicated database setup from the very first deploy — no extra configuration required.Learn more
import datasquirel from "@moduletrace/datasquirel"; datasquirel.api.crud({ action: "get", database: "dsql", table: "users", query: { query: { date_created_code: { value: "2309482989324234", equality: "LESS THAN", }, }, }, });
Developer First
Query your data from any environment using our REST API. Use our JSON-to-SQL mapping for common operations, or drop down to raw SQL when you need full control.
Use the
api method for a minimal JSON-to-SQL mapping system. Filter, sort, paginate, and join — without writing a single SQL statement.API ReferenceFeature Rich
Datasquirel ships with all the tools to manage structured data end-to-end — no plugins required.View all features
Raw SQL Support
Run any valid MariaDB SQL statement directly through the API or admin panel. Full syntax support with no restrictions.Live Database & Table Cloning
Clone a database or individual table and keep schema changes in sync with the source in real time — even across different databases.Rich Editors
Edit HTML with a full-featured rich text editor, or use the built-in editors for JSON, YAML, and Markdown — all inline in your table entries.Powerful REST API
Query, insert, update, and delete records from any environment using scoped API keys and a tightly integrated REST interface.Import & Export
Move your data freely. Export databases to multiple formats and import from SQL dumps or ZIP archives with a single action.TypeScript Type Generation
Generate TypeScript types directly from your live database schema. Keep your application code and database structure in sync automatically.Media Storage
Upload, organise, and serve files alongside your structured data. Toggle between public and private folders with time-limited access keys.Controlled Access
Invite team members and delegate access to specific databases. Scoped API keys and role-based permissions keep your data secure.And more
Automated backups, database migration, AI integration, and a self-hostable community edition — see the full list on our features page.See all features