MythQL — a wizardly database management system with its own server and magical query language.
Use magical commands like SUMMON, BRING, and FILE instead of traditional SQL. Designed for readability and wizardry.
Built-in development environment with syntax highlighting, tab management, and real-time Database updates.
Robust server architecture with user management, transaction support, and real-time Updates to all the clients when the files are changed.
Get instant updates when databases change. Perfect for collaborative environments.
Full ACID transactions with START, SEAL, and UNDO commands for data integrity.
Dark and light themes with magical color schemes that match the wizardly aesthetic. If you dont like the default ones, you can make your own easily!
SUMMON DATABASE
Create a new database
SUMMON DATABASE School
SUMMON TABLE
Create a new table
SUMMON TABLE Students {
ID INT SELF STACKABLE,
Name VARCHAR(50),
Age INT
}
BURN
Delete database or table
BURN TABLE Students
BURN DATABASE School
FILE
Insert data
FILE Students {Name, Age}
["Alice", 20], ["Bob", 22]
BRING
Query data (SELECT)
BRING Students {Name, Age}
BRING Students IN WHICH {Age} GREATER [18]
REWRITE
Update data
REWRITE Students {Age} [21]
IN WHICH {Name} EQUALS ["Alice"]
START
Begin transaction
START
SEAL
Commit transaction
SEAL
UNDO
Rollback transaction
UNDO
UNDO 3
INVOKE
Create user
INVOKE USER wizard {"magic123", ADMIN}
EMPOWER
Grant privileges
EMPOWER wizard {SELECT, INSERT}
DISARM
Revoke privileges
DISARM wizard {DELETE}
Java Swing-based interface with syntax highlighting, tab management, and real-time console
Multi-threaded server handling concurrent connections and transactions
Custom language with intuitive syntax and comprehensive features
java -jar MythQLServer.jar
java -jar MythQL.jar
# Connect to localhost:12345
SUMMON DATABASE MyRealm
UTILIZE MyRealm
SUMMON TABLE Wizards {
ID INT SELF STACKABLE,
Name VARCHAR(50),
PowerLevel INT
}
FILE Wizards {Name, PowerLevel}
["Gandalf", 95], ["Merlin", 88]
Get started instantly with our preconfigured virtual machine
Preconfigured with MythQL Server, IDE, and all dependencies
Download VM (.ova)Password: magic