Summon Your Data

MythQL — a wizardly database management system with its own server and magical query language.

Magic GIF
✨ Download Now 🪄 See Commands 💻 GitHub

✨ Magical Features

🔮 Intuitive Query Language

Use magical commands like SUMMON, BRING, and FILE instead of traditional SQL. Designed for readability and wizardry.

🪄 Wizardly IDE

Built-in development environment with syntax highlighting, tab management, and real-time Database updates.

📚 Arcane Server

Robust server architecture with user management, transaction support, and real-time Updates to all the clients when the files are changed.

⚡ Real-time Notifications

Get instant updates when databases change. Perfect for collaborative environments.

🔒 Transaction System

Full ACID transactions with START, SEAL, and UNDO commands for data integrity.

🎨 Customizable Themes

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!

🪄 MythQL Commands

📖 Data Definition

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

✏️ Data Manipulation

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"]

🔄 Transactions

START Begin transaction
START
SEAL Commit transaction
SEAL
UNDO Rollback transaction
UNDO
UNDO 3 

👥 User Management

INVOKE Create user
INVOKE USER wizard {"magic123", ADMIN}
EMPOWER Grant privileges
EMPOWER wizard {SELECT, INSERT}
DISARM Revoke privileges
DISARM wizard {DELETE}

🏰 System Architecture

🎨 MythQL IDE

Java Swing-based interface with syntax highlighting, tab management, and real-time console

  • Multi-tab query editor
  • Schema tree viewer
  • Real-time Database Updates
  • Theme system

⚡ MythQL Server

Multi-threaded server handling concurrent connections and transactions

  • User authentication
  • Transaction management
  • Real-time Database Updates
  • CSV-based storage

🔮 Query Language

Custom language with intuitive syntax and comprehensive features

  • DDL & DML operations
  • JOIN operations
  • User management (DCL)
  • Transaction control

🚀 Quick Start

1. Start the Server
java -jar MythQLServer.jar
2. Connect with IDE
java -jar MythQL.jar
# Connect to localhost:12345
3. Run Your First Commands
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]

Download MythQL

Get started instantly with our preconfigured virtual machine

🖥️ Virtual Machine

Preconfigured with MythQL Server, IDE, and all dependencies

Download VM (.ova)

Password: magic

System Requirements
  • VirtualBox 6.0 or newer
  • 4GB RAM minimum (8GB recommended)
  • 20GB free disk space
  • Java Runtime Environment 8+