Console
Query this site.
Everything on this portfolio lives in a schema rather than in markup, so it can be queried. The engine below is a tokeniser, parser and evaluator written for this page: no dependency, a few kilobytes, running entirely in your browser.
It is a demonstration, not a database server. The rows are shipped with the page and the policy layer is modelled rather than enforced by Postgres. The real version of this idea, on 85 tables that do enforce it, is PluginZ HR.
Schema
slug, name, category, year, tier, featured, source, live
project, value, label
project, layer, tech
tech, layer
company, role, period, place
area, summary
channel, value
table_name, command, role, using_expression
8 rows
8 rows
| name | category | year |
|---|---|---|
| Alkamnja | LMS · E-learning | 2026 |
| Byway LMS | LMS · Marketplace | 2026 |
| Alpenglow Retreat | Hospitality · Ops | 2026 |
| Moonlight Store | E-commerce | 2026 |
| Nizami Cinema | Booking | 2026 |
| PluginZ HR / ATS | Ops360 · Product | 2025 – present |
| AkhshabZ | Business system | 2025 |
| PluginZ Corporate Site | Marketing site | 2025 |
Reference
The schema
Eight tables, derived from the same data the rest of the site renders from.
projects
11 rows
One row per system I have shipped.
- slug
- text
- name
- text
- category
- text
- year
- text
- tier
- text
- featured
- bool
- source
- text
- live
- text
project_metrics
21 rows
The headline figures on each case page.
- project
- text
- value
- text
- label
- text
project_stack
133 rows
What each project is built out of. Join it against projects.
- project
- text
- layer
- text
- tech
- text
stack
41 rows
Everything I work with, grouped by layer.
- tech
- text
- layer
- text
experience
3 rows
Where I have worked.
- company
- text
- role
- text
- period
- text
- place
- text
capabilities
4 rows
What I do, in four areas.
- area
- text
- summary
- text
contact
restricted
Restricted. Assume a role to read it.
- channel
- text
- value
- text
policies
9 rows
The row-level security policies on the tables above.
- table_name
- text
- command
- text
- role
- text
- using_expression
- text
Prefer prose? The same work, written out, or email me.