Software engineer working on developer tools, backend systems and data-heavy applications.
ASK DATABASE - schema-aware NL-to-SQL
Ask a question about a database and get SQL with the reasoning context kept visible. The backend retrieves the relevant schema, glossary entries, aliases and sanitized historical queries, ranks relationship paths, generates structured SQL and validates it before returning it.
How it is built
- Schema, Query and Correction Memory stored in PostgreSQL
- Deterministic schema retrieval and relationship-path ranking
- Backend LLM provider boundary with Structured Outputs and Zod
- Safe Mode restricts results to validated
SELECTandWITHqueries - Evidence and a decision log are returned with generated SQL
SQL Atlas - local-first SQL analysis
Deterministic analysis that runs entirely in the browser. SQL Atlas detects anti-patterns, explains findings, suggests indexes from query structure and compares PostgreSQL, MySQL, Oracle, SQLite and SQL Server. Queries are not uploaded to a server.
What is inside
- Rule-based analyzer with severity, scoring and passed checks
- Index suggestions based on filters, joins, grouping and ordering
- PostgreSQL EXPLAIN JSON parser with metrics, execution tree and risk detection
- Before and after rewrites, query map and Markdown report export
- Roadmap: CLI and repository-level checks
VisualDB Studio - visual schema design
An interactive PostgreSQL schema modeller. Tables and relationships are edited on a visual canvas. The resulting model can be validated, scored and exported as SQL without hiding the underlying database design.
Capabilities
- Table, column, key, constraint and relationship editing
- PostgreSQL DDL generation, including indexes and foreign keys
- Schema validation, quality scoring and index recommendations
- Templates and suggestions for extending an existing model
OraBank - Oracle database engineering
An Oracle SQL and PL/SQL project covering customers, accounts, cards, transfers, loans and audit data. The transfer package uses deterministic row locking, savepoints and paired transaction records without hiding commits from callers.
Database engineering scope
- SQL and PL/SQL packages for accounts, balances, loans and transfers
- Indexing, query analysis and optional interval partitioning
- Roles, privileges, reporting views and audit access
- Scheduler jobs plus backup and recovery runbooks
- Validation and smoke-test scripts for an Oracle environment
- Application: TypeScript, React, Node.js, Fastify
- Data: PostgreSQL, Oracle, Supabase
- Delivery: GitHub Actions, Docker, Vercel
RehabOS is software for physiotherapy practices. The work covers clinic operations, therapist workflows and the patient side of care between visits. It is still in development and is not presented here as a finished public product.
Recent merged pull requests
- tungbq/devops-project #128 - corrected a Terraform VPN access guideline
- vitorfranklin/retrohost #26 - resolved Markdown lint issues
- thomaspinder/GPJax #685 - corrected GraphKernel spectral documentation
- Sklearn-genetic-opt #304 - updated community documentation references