Drizzle Studio

New cli command is available drizzle-kit studio

Drizzle Studio is a helper for data visualization. It seamlessly integrates with your existing data infrastructure by reading the drizzle.config file and establishing a connection to your specified database. Studio supports all drivers, including pg, mysql2, better-sqlite, libsql, and even turso driver!

Available actions

1. Retrieve a list of all tables in the schema.
2. Obtain the row count for each table.
3. Perform table selection with options such as limit, offset, filters, and partial select.
4. View all relations defined by the Relational Queries utility.
5. Create, update, and delete entities from tables.
6. Benefit from basic type validation.

Available cli options

1. --port=3000 - By default, Drizzle will use port 4983, but you can specify any port you desire
2. --verbose - With this flag, you can print all statements that Drizzle Studio will execute while you browse through your data

For more information please check: https://driz.li/meet-studio

Improvements Roadmap

1. Enhance validations with helpers such as datepicker, JSON validation, and more.
2. Expand the range of filter options available.
3. Introduce a schema change listener.
4. And much more!

Bug fixes

1. Correct the wrong typing option for SQLite generate and push commands when using autoincrement.
2. Address the SQLite push issue that generates incorrect defaults for booleans.
3. Resolve the SQLite push issue where unnecessary migrations are generated for composite primary keys.