Lorapok Querycraft

Tactician's Logbook — UI Design Pass

Eight core mobile screens showing the app's visual language in context: saved connections, add-connection form, data grid CRUD, the query playground with live autocomplete, the key-gated AI assistant, multi-provider AI settings, general app settings (fetch limits + schema visibility), and the about screen. Scroll the rail horizontally on desktop, or swipe on mobile.

Base #030711
Neon green — primary / READ
Electric cyan — schema / data
Gold — AI / WRITE risk
Danger — DESTRUCTIVE
Playfair Display SC · Space Mono · Lora
01 — Connections
9:41●●●● 5G

Querycraft

âš™
Saved Connections
Shohoz Live — Production
mysql://prod-db.internal:3306
ConnectedSSH tunnel
Shohoz Bus — Beta
localhost:3306 / shohoz_beta
Idle
LaraCommerce Dev
127.0.0.1:3306 / laracommerce
Idle
Recent Schemas
orders · customers · shohozlive_tickets · inventory
+
02 — Add New Connection
9:41●●●● 5G
Cancel

New Connection

Save
Alias
e.g. Production — Orders DB
Color tag
Connection Type
Default
Unix Socket
URL only
Host
prod-db.internal
Port
3306
User
db_user
Password
••••••••
Forever
Session only
Never
Default Database
Select schema â–¾
SSH Tunnelâ–¸
Advanced Parametersâ–¸
Require SSL/TLS● ON
Test Connection
03 — Data Grid & CRUD
9:41●●●● 5G

orders

1,204 rows
orders
customers
inventory
payments
status = pending ×
created_at > 2026-07-01 ×
id
customer
status
total
10231
M. Rahman
pending
$412
10232
S. Chowdhury
paid
$88
10233
A. Hasan
pending
$1,240
10234
T. Islam
paid
$56
10235
N. Akter
pending
$322
10236
R. Karim
paid
$710
✎ edit selected⤓ export✕ delete
04 — Query Playground
9:41●●●● 5G

Playground

AI: ON
1SELECT o.id, o.status, c.name
2FROM orders o
3JOIN customers c ON o.customer_id = c.id
4WHERE o.status = 'pending'
5ORDER BY o.created_at DESC;
â–¤ created_at
â–¤ customer_id
â–¤ status
⌘ COUNT(*)
42 rows · 0.014s ⤓ Export ▾
id
status
name
10231
pending
M. Rahman
10233
pending
A. Hasan
05 — Ask-DB (AI Assistant)
9:41●●●● 5G

Ask DB

Claude · Sonnet
Show me all pending orders over $300 with the customer's name
READ orders, customers
SELECT o.id, o.total, c.name
FROM orders o
JOIN customers c ON o.customer_id = c.id
WHERE o.status = 'pending' AND o.total > 300;
Joins orders to customers on customer_id, filtering to pending orders over $300. No index found on (status, total) — consider adding one if this runs often.
Edit
Run query
⤓ Export result after run
Ask about your database…
06 — Settings · AI Providers
9:41●●●● 5G

AI Providers

Anthropic
sk-ant-••••••••••••7f2a
claude-sonnet-4-6 â–¾Test & Save
OpenAI
Add API key…
gpt-4.1 â–¾Test & Save
Google Gemini
Add API key…
gemini-2.5-pro â–¾Test & Save
Groq
Add API key…
llama-3.3-70b â–¾Test & Save
Default provider
● Anthropic — used unless overridden per request
07 — Settings · General & Data
9:41●●●● 5G

Settings

Data Fetching
Initial row limit
rows loaded on first table open
– 100 +
Page size
rows per scroll page
– 50 +
Query timeout
seconds before auto-cancel
– 30s +
Visible Databases — Shohoz Live
Select AllClear
orders
18 tables
customers
6 tables
inventory
11 tables
analytics_archive
42 tables
information_schema
system
Export Defaults
Default format
used for the quick-export button
CSV â–¾
Include column headers
Security
Biometric lock
required after backgrounding
Auto-lock timeout
– 5m +
08 — About
9:41●●●● 5G

About

Lorapok Querycraft

v1.0.0 (build 2026.07.14)
Developed by
Lorapok Labs — an open-source software collective based in Dhaka, Bangladesh.
github.com/lorapok
lorapok.github.io
Founder
Lorapok (@Maijied)
Features
✓ Full CRUD & visual filtering
✓ CSV / JSON / SQL export, everywhere
✓ Encrypted, session-based connections
✓ Schema-aware autocomplete
✓ Multi-provider AI, key-gated
✓ Biometric session lock
Open Source
Published under the Lorapok Labs brand. Licensed for free use and contribution — see repository for license terms.
© 2026 Lorapok Labs. All rights reserved.