Miraj Database — The SQL database built for speed
{{ T.newBadge }} {{ T.annMsg }} {{ T.learnMore }}
Miraj Miraj Database
{{ n.label }}
Miraj Database

{{ T.heroTitle }}

{{ T.heroTag }}

{{ T.heroLead }}

{{ T.chip1 }}{{ T.chip2 }}{{ T.chip3 }}{{ T.chip4 }}{{ T.chip5 }}
{{ T.benchTitle }} {{ bench.unit }}
{{ r.name }}
{{ r.v }}
{{ bench.note }} {{ T.benchFoot }}
{{ T.howLabel }}

{{ T.howTitle }}

{{ T.howLead }}

{{ h.n }}
{{ h.t }} {{ h.d }}
{{ T.qplan }} {{ hero.status }}
SELECT region, SUM(amount) FROM sales GROUP BY region;
{{ T.parseOpt }}
{{ T.memTitle }}{{ hero.memNote }}
{{ c.name }}
{{ T.cpuTitle }}{{ T.cores8 }}
{{ l.label }}
{{ T.result }}
{{ r.k }}{{ r.v }}
{{ T.durable }}
{{ T.walSynced }}
{{ T.rows }} {{ hero.rowsScanned }} {{ T.workers }} 8 {{ T.time }} {{ hero.time }}
{{ T.archLabel }}

{{ T.archTitle }}

{{ T.archLead }}

{{ T.colTitle }}

{{ T.colDesc }}

{{ T.colNote }}

{{ T.memProcTitle }}

{{ T.memProcDesc }}

CPU
RAM
DISK
{{ T.memProcNote }}

{{ T.mcTitle }}

{{ T.mcDesc }}

{{ T.mcNote }}

{{ T.dsTitle }}

{{ T.dsDesc }}

{{ T.dsNote }}

{{ T.diskTitle }}

{{ T.diskDesc }}

{{ T.inMem }} orders · customers {{ T.hot }}
{{ T.onDisk }} orders_2019 · audit_log {{ T.cold }}
SQL

{{ T.sqlTitle }}

{{ T.sqlLead }}

revenue.sql
{{ T.schema }}
miraj-cli · sales_db
1SELECT
2 customer_id,
3 SUM(amount) AS revenue,
4 COUNT(*) AS orders
5FROM sales
6WHERE order_date >= '2026-01-01'
7GROUP BY customer_id
8ORDER BY revenue DESC;
{{ m.k }} {{ m.v }}
{{ T.pipeline }}
{{ s.label }} {{ s.sub }}
{{ T.deployLabel }}

{{ T.deployTitle }}

→ {{ f.t }}

{{ m.title }}

{{ m.bin }}

{{ m.desc }}

{{ t }}
{{ T.edLabel }}

{{ T.edTitle }}

{{ T.edLead }}

{{ T.compare }}
{{ e.name }}{{ e.tag }}

{{ e.desc }}

{{ T.execLabel }}{{ e.exec }}
{{ T.replLabel }}{{ e.repl }}
{{ T.forLabel }}
{{ f }}
{{ T.mcpLabel }}

{{ T.mcpTitle }}

{{ T.mcpLead }}

{{ c }}
{{ T.mcpLevel }}
{{ o.op }} {{ o.state }}
{{ T.aiAssistant }}Claude · ChatGPT · DeepSeek
{{ T.mcpClient }}
MCP Server{{ T.scopedToken }}
{{ T.token }}   mrj_tk_7f3a…c91e
{{ T.account }} analyst
{{ T.level }}   {{ mcp.levelName }}
{{ T.noSql }}
{{ T.engine }}{{ T.engineSub }}
{{ T.database }}sales_db
{{ T.mcpGuide }}
{{ T.vecLabel }}

{{ T.vecTitle }}

{{ T.vecLead }}

{{ T.vecRef }}
01→
{{ d.n }}
{{ T.vDocs }}
02→
{{ d.v }}
{{ T.vEmb }}
03→
{{ T.vIdx }}
04→
{{ T.vSim }}
05
doc_iddistance
{{ r.id }}{{ r.d }}
{{ T.vRes }}
CREATE VECTOR INDEX idx_docs_embedding ON documents (embedding);
{{ T.clLabel }}

{{ T.clTitle }}

{{ T.clLead }}

{{ p.t }}{{ p.d }}
{{ T.clGuide }}
{{ T.writes }}
PRIMARY
lsn {{ cluster.lsn }}
{{ T.replication }}
SECONDARY
{{ T.readOnly }}
lsn {{ n.lsn }}
{{ T.appRead }} {{ T.appRead }}
{{ T.bkLabel }}

{{ T.bkTitle }}

{{ T.bkLead }}

{{ T.bk1t }}{{ T.bk1d }}
{{ T.bk2t }}{{ T.bk2d }}
{{ T.bk3t }}{{ T.bk3d }}
{{ T.bk4t }}{{ T.bk4d }}
{{ T.bkGuide }}
{{ T.bkTimeline }}{{ T.bkLineage }}
{{ T.fullBackup }}
.mra
.mra
.mra
{{ T.untilTime }}
{{ T.sqlc1 }} SET GLOBAL journal_archive_dir = 'D:\\Miraj archive'; SET GLOBAL journal_archive = ON; {{ T.sqlc2 }} RESTORE DATABASE sales_1530 FROM 'daily/sales' WITH ARCHIVE UNTIL TIME '2026-09-29 15:30:00';
{{ T.ecoLabel }}

{{ T.devTitle }}

{{ T.devLead }}

{{ T.readDocs }}
{{ T.embed }} {{ T.clientApis }}
{{ l.n }} {{ l.d }}
{{ T.restLabel }}

{{ T.restTitle }}

{{ T.restLead }}

{{ T.restRef }}
{{ f.name }} {{ f.state }}
{{ f.path }} {{ f.d }}
{{ t }}
endpoint.sql{{ T.apiInSql }}
CREATE ENDPOINT customer GET '/customers/{id}' PARAMS (id INT) RETURNS ONE AS SELECT id, name, city FROM customers WHERE id = :id; CREATE API TOKEN mobile {{ T.forLabel }} 'app'@'%' ACCESS ENDPOINTS;
{{ T.request }}HTTPS :7009
GET /customers/42 Authorization: Bearer mja_… 200 OK { "id": 42, "name": "Ali", "city": "Oran" }
{{ T.migLabel }}

{{ T.migTitle }}

{{ T.migLead }}

{{ T.migExplore }}
{{ T.myLabel }}

{{ T.myTitle }}

{{ T.myLead }}

{{ T.same1 }} {{ T.same2 }} {{ T.same3 }}
config/database.env{{ T.oneLine }}
  DB_HOST=db.internal
- DB_PORT=3306
+ DB_PORT=7007
  DB_USER=app
  DB_NAME=sales_db
{{ T.yourApp }} → :7007 → Miraj
{{ T.source }}
{{ T.existingApp }}{{ T.existingSub }}
{{ T.migTools }}
miraj-migrate miraj-dump SQL {{ T.backupRestore }}
{{ T.target }}
Miraj Database{{ T.verified }}
{{ T.docLabel }}

{{ T.docTitle }}

{{ T.readDocs }}
Mirajv1.0
{{ T.search }}Ctrl K
{{ T.docsCrumb }} / {{ docs.cur.t }}

{{ docs.cur.t }}

{{ docs.cur.d }}

{{ docs.cur.code }}
{{ T.openChapter }}

{{ T.ctaTitle }}

{{ T.ctaLead }}

{{ dl.title }}
{{ dl.versionLabel }}
{{ st.label }}

{{ dl.stepTitle }}

{{ dl.stepHelp }}

{{ dl.pickVersion }}
{{ dl.yourChoice }}
{{ r.k }}{{ r.v }}
{{ dl.file }}
{{ dl.error }}
{{ dl.thanksMsg }}
{{ dl.finalMsg }}
{{ dl.file }}
{{ dl.retry }} {{ dl.shaLabel }} · {{ dl.docLabel }}
{{ dl.paidLabel }}