SQL-Engineering-Handbook

SQL Engineeering Handbook by Mohammad Ammar. Production-ready with SQL tutorials, interview questions, real-world projects, query optimization, window functions, and analytics engineering examples. Created by the Co-Founder of Apex Analyticx. Live Portfolio: https://theammarngp.lovable.app

A new way for AI to search for data

View on GitHub

13GitHub stars

332commits on main

4forks

v1.1.0latest release, 2026-08-04

SQL 96.6%, Python 2.4%, Shell 0.9%, Mermaid 0.1% · created 2026-06-16 · last push 2026-10-25

What XERJ indexed

Snapshot

Whole repository

The whole repository at commit 1e9363f877. It is the newest commit on main.

Selected work

Mohammad Ammar
@theammarngp-makes

Licence

The repository

MIT

LICENSE file checked at the pinned commit; the author agreed to inclusion.

The XERJ corpus

MIT, with credit

The owner added it on hub.xerj.org after signing in with GitHub, on 2026-10-29. Same terms as the repository. Answers name the repo, the commit and the file:line.

selected for the XERJ Corpus Hublicence clearedsuggested use: adapt with attribution

mysqlsqlsql-tutorialanalyticsanalytics-engineeringbusiness-intelligencedata-analysisdata-engineering

Example questions

How does SQL-Engineering-Handbook implement mysql?
Show the sql code in SQL-Engineering-Handbook.

Inside the indexed corpus

Languages by size: SQL 96.6%, Python 2.4%, Shell 0.9%, Mermaid 0.1%.
On GitHub since 2026-06-16, last push 2026-10-25, 332 commits on main.

Licence on GitHub and in the corpus

GitHub reported MIT for theammarngp-makes/SQL-Engineering-Handbook on 2026-10-31, and the LICENSE file at commit 1e9363f877 was reviewed as MIT. They match, so answers from this corpus carry the same terms as the live repository.

Contributors

Mohammad Ammar (@theammarngp-makes) has 2 selected repositories on the hub.

Their other repository pages: theammarngp-makes/monthly-revenue-growth-analysis.

Using XERJ with SQL-Engineering-Handbook

Search a SQL dump without restoring it SQL-Engineering-Handbook is tagged database on GitHub.
Best MCP servers for local code search in 2026, compared
Best grep alternative for AI coding agents (2026)
Ask questions about a GitHub repo without cloning it

The prompt

Paste it into your AI agent. It clones theammarngp-makes/SQL-Engineering-Handbook at the pinned commit and indexes it on your machine.

Search the GitHub repository theammarngp-makes/SQL-Engineering-Handbook with XERJ (https://hub.xerj.org/corpus/theammarngp-makes--sql-engineering-handbook).
Run these in a shell, in order, and check each result before the next:
1. xerj --help  (success: it prints usage). If xerj is missing: curl -fsSL https://xerj.org/get | sh
2. git clone https://github.com/theammarngp-makes/SQL-Engineering-Handbook SQL-Engineering-Handbook && git -C SQL-Engineering-Handbook checkout 1e9363f87731d419ecc24df0f4e5af911615398d
3. Start a local node and leave it running: xerj --insecure --data-dir ./xerj-data
4. xerj autoindex ./SQL-Engineering-Handbook --url http://127.0.0.1:9200 --prefix sql-engineering-handbook --progress plain
5. xerj autoindex map --url http://127.0.0.1:9200
Then answer my question from the indexed files and cite the ax_path of every hit. Query syntax: https://xerj.org/llms.txt
Licence: MIT. Keep the copyright notice and credit the authors.

Mohammad Ammar Databases and storage engines corpora duckdb xerj-columnar cloudnative-pg Analytically-ai/truequery libredb/libredb-studio farzanshibu/db-free

Stats: GitHub API, fetched 2026-10-31. Selected work and consent: the XERJ registry.