The Great v3 Studio Update

DB Studio

A fully visual, drag-and-drop database architect natively integrated into your CLI. Map relations, edit live data, and generate complex SQL/PHP classes without writing a single query.

Visual ER Mapper

Design your database visually. Drag tables, draw foreign key relationships, and manage columns. When you are ready, hit "Apply" and DB Studio compiles the architecture directly into your live project.

Stateful .artiframe Backups

DB Studio saves your entire canvas as a secure binary/JSON .artiframe file. This eliminates the risk of raw SQL files polluting your GitHub repo or exposing sensitive schema data in emails. Share your architecture safely and professionally.

logo ArtiFrame Studio
Tables
users
roles
users
PK idINT(11) AI
role_idINT(11)
emailVARCHAR(255)
+ Sütun Ekle
roles
PK idINT(11) AI
nameVARCHAR(50)
✨ Yeni Tablo Ekle
📥 İçe Aktar (.artiframe)
📤 Dışa Aktar (.artiframe)
Sütun Düzenle (is_active)
BOOLEAN (Mantıksal)
MySQL'de yerleşik Boolean yoktur, bu yüzden TINYINT(1) olarak çevrilir.

NoSQL-Style Schema Editor

Manage columns without SQL syntax. DB Studio automatically maps types (e.g., BOOLEAN to TINYINT). Quickly toggle INDEX or UNIQUE constraints using visual checkboxes directly from the column editor.

Two-Way SQL Synchronization

Every change made in the GUI generates real-time ALTER/CREATE diffs. With one click, DB Studio safely executes the changes on the active database and syncs your project's native .sql schema file simultaneously.

Şema Senkronizasyonu
1 Tablo eklendi, 2 sütun değiştirildi. Veritabanını güncelleyip projedeki schema.sql dosyasını senkronize etmek istiyor musunuz?
ALTER TABLE `users` ADD COLUMN `is_active` TINYINT(1) DEFAULT 1; ALTER TABLE `users` ADD INDEX `idx_is_active` (`is_active`); CREATE TABLE `products` ( `id` INT(11) AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(255) NOT NULL ) ENGINE=InnoDB;
Geri alınamaz işlem.
ER Mapper
SQL Konsolu
Live Sheet
SQL Editor
2 row(s) returned.
email role_name
[email protected] Admin
[email protected] User

Raw SQL Console for Seniors

While the visual builders handle 95% of use cases, senior developers still have full control. Write, execute, and test raw SQL queries instantly with the built-in SQL Console. No external desktop clients needed.

Live Data Sheet

Interact with your database like a spreadsheet. Add, edit, or delete rows instantly in a powerful data-grid view without writing INSERT or UPDATE queries.

ER Mapper
SQL Konsolu
Live Sheet
id role_id email İşlem
1 1 [email protected]
2 2 [email protected]
Query Builder
INNER roles ON roles.id = users.role_id
Auto-Generated Code
public static function getActiveUsers() { return SystemMethod::db()->query(" SELECT * FROM users INNER JOIN roles ON roles.id = users.role_id ")->fetchAll(); }

Visual Query & Class Builder

Need complex queries with JOINS and WHERE clauses? Use the visual builder to construct your query, and DB Studio will instantly generate the pure PHP code and SQL string for you to copy into your controllers.

Beyond Traditional Database Tools

Forget phpMyAdmin or complex desktop clients. DB Studio runs directly inside your local environment, completely aware of your project. It saves your architecture in binary .artiframe files, allowing instant offline schema previews and lightning-fast syncing.

Two-Way SQL Synchronization

Every change made in the GUI generates real-time ALTER/CREATE diffs. With one click, DB Studio safely executes the changes on the active database and syncs your project's native .sql schema file simultaneously.

Stateful .artiframe Backups

DB Studio saves your entire canvas as a secure binary/JSON .artiframe file. This eliminates the risk of raw SQL files polluting your GitHub repo or exposing sensitive schema data in emails. Share your architecture safely and professionally.

Visual ER Mapper

Design your database visually. Drag tables, draw foreign key relationships, and manage columns. When you are ready, hit "Apply" and DB Studio compiles the architecture directly into your live project.

Raw SQL Console for Seniors

While the visual builders handle 95% of use cases, senior developers still have full control. Write, execute, and test raw SQL queries instantly with the built-in SQL Console. No external desktop clients needed.

NoSQL-Style Schema Editor

Manage columns without SQL syntax. DB Studio automatically maps types (e.g., BOOLEAN to TINYINT). Quickly toggle INDEX or UNIQUE constraints using visual checkboxes directly from the column editor.

Visual Query & Class Builder

Need complex queries with JOINS and WHERE clauses? Use the visual builder to construct your query, and DB Studio will instantly generate the pure PHP code and SQL string for you to copy into your controllers.