https://github.com/xataio/learn-postgres
· scanned 2026-06-16 01:01 UTC (2 months, 1 week ago)
28 raw signals (0 security + 28 graph)
Last scanned 2 months, 1 week ago · v1 · 28 actionable findings from 1 signal source. Security checks, system graph analysis, and verified AI-agent feedback are merged into one review queue.
All 462 nodes from the latest scan, grouped by kind. Each node is a unit the engine identified (file, function, endpoint, table…). Most users won't need this view — it's primarily for debugging the engine's graph extraction or for AI agents that want to enumerate the project structure.
| Label | Layer | Status | Path |
|---|---|---|---|
requireEnv |
software | healthy | scripts/xata-cleanup.ts:requireEnv |
call |
software | healthy | scripts/xata-cleanup.ts:call |
main |
software | healthy | scripts/xata-cleanup.ts:main |
keep |
software | healthy | scripts/xata-cleanup.ts:keep |
loadLessonSeeds |
software | healthy | scripts/prepare-templates.ts:loadLessonSeeds |
resolveMainParent |
software | healthy | scripts/prepare-templates.ts:resolveMainParent |
seedTemplate |
software | healthy | scripts/prepare-templates.ts:seedTemplate |
msg |
software | healthy | scripts/prepare-templates.ts:msg |
main |
software | healthy | scripts/prepare-templates.ts:main |
validateOne |
software | healthy | scripts/validate-lessons.ts:validateOne |
sql |
software | healthy | scripts/validate-lessons.ts:sql |
main |
software | healthy | scripts/validate-lessons.ts:main |
titleize |
software | healthy | scripts/new-lesson.ts:titleize |
findModuleDir |
software | healthy | scripts/new-lesson.ts:findModuleDir |
nextLessonOrder |
software | healthy | scripts/new-lesson.ts:nextLessonOrder |
main |
software | healthy | scripts/new-lesson.ts:main |
PoweredByXata |
software | healthy | components/PoweredByXata.tsx:PoweredByXata |
ThemeToggle |
software | healthy | components/ThemeToggle.tsx:ThemeToggle |
onClick |
software | healthy | components/ThemeToggle.tsx:onClick |
ForceLightTheme |
software | healthy | components/badge/ForceLightTheme.tsx:ForceLightTheme |
BadgeCard3D |
software | healthy | components/badge/BadgeCard3D.tsx:BadgeCard3D |
onPointerMove |
software | healthy | components/badge/BadgeCard3D.tsx:onPointerMove |
px |
software | healthy | components/badge/BadgeCard3D.tsx:px |
py |
software | healthy | components/badge/BadgeCard3D.tsx:py |
onPointerLeave |
software | healthy | components/badge/BadgeCard3D.tsx:onPointerLeave |
SandboxPanel |
software | healthy | components/lesson/SandboxPanel.tsx:SandboxPanel |
onClearShell |
software | healthy | components/lesson/SandboxPanel.tsx:onClearShell |
onReset |
software | healthy | components/lesson/SandboxPanel.tsx:onReset |
Spinner |
software | healthy | components/lesson/SandboxPanel.tsx:Spinner |
BranchPanel |
software | healthy | components/lesson/BranchPanel.tsx:BranchPanel |
RestoreScroll |
software | healthy | components/lesson/RestoreScroll.tsx:RestoreScroll |
SandboxSignInPrompt |
software | healthy | components/lesson/SandboxSignInPrompt.tsx:SandboxSignInProm… |
buildLessonComponents |
software | healthy | components/lesson/mdx-components.tsx:buildLessonComponents |
CheckCard |
software | healthy | components/lesson/Check.tsx:CheckCard |
onRun |
software | healthy | components/lesson/Check.tsx:onRun |
json |
software | healthy | components/lesson/Check.tsx:json |
stylesFor |
software | healthy | components/lesson/Check.tsx:stylesFor |
Spinner |
software | healthy | components/lesson/Check.tsx:Spinner |
SandboxSection |
software | healthy | components/lesson/SandboxSection.tsx:SandboxSection |
SandboxLoading |
software | healthy | components/lesson/SandboxLoading.tsx:SandboxLoading |
Spinner |
software | healthy | components/lesson/SandboxLoading.tsx:Spinner |
RunBlock |
software | healthy | components/lesson/RunBlock.tsx:RunBlock |
onRun |
software | healthy | components/lesson/RunBlock.tsx:onRun |
read |
software | healthy | components/shell/history.ts:read |
write |
software | healthy | components/shell/history.ts:write |
loadHistory |
software | healthy | components/shell/history.ts:loadHistory |
pushHistory |
software | healthy | components/shell/history.ts:pushHistory |
clearHistory |
software | healthy | components/shell/history.ts:clearHistory |
padRight |
software | healthy | components/shell/format.ts:padRight |
padLeft |
software | healthy | components/shell/format.ts:padLeft |
Showing first 50 of this kind. Full payload available via the JSON button at the top of the page.
| Label | Layer | Status | Path |
|---|---|---|---|
vercel.json |
software | healthy | vercel.json |
postcss.config.mjs |
software | healthy | postcss.config.mjs |
README.md |
software | healthy | README.md |
CLAUDE.md |
software | healthy | CLAUDE.md |
package.json |
software | healthy | package.json |
CONTRIBUTING.md |
software | healthy | CONTRIBUTING.md |
package-lock.json |
software | healthy | package-lock.json |
.env.example |
software | healthy | .env.example |
tsconfig.json |
software | healthy | tsconfig.json |
drizzle.config.ts |
software | healthy | drizzle.config.ts |
eslint.config.mjs |
software | healthy | eslint.config.mjs |
PLAN.md |
software | healthy | PLAN.md |
AGENTS.md |
software | healthy | AGENTS.md |
next.config.ts |
software | healthy | next.config.ts |
module.yaml |
software | healthy | lessons/03-combining-tables/module.yaml |
seed.sql |
software | healthy | lessons/03-combining-tables/04-subqueries/seed.sql |
lesson.yaml |
software | healthy | lessons/03-combining-tables/04-subqueries/lesson.yaml |
seed.sql |
software | healthy | lessons/03-combining-tables/02-advanced-joins/seed.sql |
lesson.yaml |
software | healthy | lessons/03-combining-tables/02-advanced-joins/lesson.yaml |
seed.sql |
software | healthy | lessons/03-combining-tables/03-set-operations/seed.sql |
lesson.yaml |
software | healthy | lessons/03-combining-tables/03-set-operations/lesson.yaml |
seed.sql |
software | healthy | lessons/03-combining-tables/01-joins/seed.sql |
lesson.yaml |
software | healthy | lessons/03-combining-tables/01-joins/lesson.yaml |
module.yaml |
software | healthy | lessons/04-schema-and-modeling/module.yaml |
seed.sql |
software | healthy | lessons/04-schema-and-modeling/02-dates-and-times/seed.sql |
lesson.yaml |
software | healthy | lessons/04-schema-and-modeling/02-dates-and-times/lesson.ya… |
seed.sql |
software | healthy | lessons/04-schema-and-modeling/04-ddl-and-schemas/seed.sql |
lesson.yaml |
software | healthy | lessons/04-schema-and-modeling/04-ddl-and-schemas/lesson.ya… |
seed.sql |
software | healthy | lessons/04-schema-and-modeling/03-constraints/seed.sql |
lesson.yaml |
software | healthy | lessons/04-schema-and-modeling/03-constraints/lesson.yaml |
seed.sql |
software | healthy | lessons/04-schema-and-modeling/01-data-types/seed.sql |
lesson.yaml |
software | healthy | lessons/04-schema-and-modeling/01-data-types/lesson.yaml |
seed.sql |
software | healthy | lessons/04-schema-and-modeling/05-normalization/seed.sql |
lesson.yaml |
software | healthy | lessons/04-schema-and-modeling/05-normalization/lesson.yaml |
module.yaml |
software | healthy | lessons/05-intermediate-querying/module.yaml |
seed.sql |
software | healthy | lessons/05-intermediate-querying/03-window-functions/seed.s… |
lesson.yaml |
software | healthy | lessons/05-intermediate-querying/03-window-functions/lesson… |
seed.sql |
software | healthy | lessons/05-intermediate-querying/01-conditional-expressions… |
lesson.yaml |
software | healthy | lessons/05-intermediate-querying/01-conditional-expressions… |
seed.sql |
software | healthy | lessons/05-intermediate-querying/02-cte/seed.sql |
lesson.yaml |
software | healthy | lessons/05-intermediate-querying/02-cte/lesson.yaml |
module.yaml |
software | healthy | lessons/01-query-fundamentals/module.yaml |
seed.sql |
software | healthy | lessons/01-query-fundamentals/01-select-basics/seed.sql |
lesson.yaml |
software | healthy | lessons/01-query-fundamentals/01-select-basics/lesson.yaml |
seed.sql |
software | healthy | lessons/01-query-fundamentals/02-where-conditions/seed.sql |
lesson.yaml |
software | healthy | lessons/01-query-fundamentals/02-where-conditions/lesson.ya… |
seed.sql |
software | healthy | lessons/01-query-fundamentals/04-aggregations/seed.sql |
lesson.yaml |
software | healthy | lessons/01-query-fundamentals/04-aggregations/lesson.yaml |
seed.sql |
software | healthy | lessons/01-query-fundamentals/03-sorting-and-pagination/see… |
lesson.yaml |
software | healthy | lessons/01-query-fundamentals/03-sorting-and-pagination/les… |
Showing first 50 of this kind. Full payload available via the JSON button at the top of the page.
| Label | Layer | Status | Path |
|---|---|---|---|
lessons |
software | healthy | lessons |
03-combining-tables |
software | healthy | lessons/03-combining-tables |
04-subqueries |
software | healthy | lessons/03-combining-tables/04-subqueries |
02-advanced-joins |
software | healthy | lessons/03-combining-tables/02-advanced-joins |
03-set-operations |
software | healthy | lessons/03-combining-tables/03-set-operations |
01-joins |
software | healthy | lessons/03-combining-tables/01-joins |
04-schema-and-modeling |
software | healthy | lessons/04-schema-and-modeling |
02-dates-and-times |
software | healthy | lessons/04-schema-and-modeling/02-dates-and-times |
04-ddl-and-schemas |
software | healthy | lessons/04-schema-and-modeling/04-ddl-and-schemas |
03-constraints |
software | healthy | lessons/04-schema-and-modeling/03-constraints |
01-data-types |
software | healthy | lessons/04-schema-and-modeling/01-data-types |
05-normalization |
software | healthy | lessons/04-schema-and-modeling/05-normalization |
05-intermediate-querying |
software | healthy | lessons/05-intermediate-querying |
03-window-functions |
software | healthy | lessons/05-intermediate-querying/03-window-functions |
01-conditional-expressions |
software | healthy | lessons/05-intermediate-querying/01-conditional-expressions |
02-cte |
software | healthy | lessons/05-intermediate-querying/02-cte |
01-query-fundamentals |
software | healthy | lessons/01-query-fundamentals |
01-select-basics |
software | healthy | lessons/01-query-fundamentals/01-select-basics |
02-where-conditions |
software | healthy | lessons/01-query-fundamentals/02-where-conditions |
04-aggregations |
software | healthy | lessons/01-query-fundamentals/04-aggregations |
03-sorting-and-pagination |
software | healthy | lessons/01-query-fundamentals/03-sorting-and-pagination |
02-changing-data |
software | healthy | lessons/02-changing-data |
01-insert-and-update |
software | healthy | lessons/02-changing-data/01-insert-and-update |
02-delete-and-lifecycle |
software | healthy | lessons/02-changing-data/02-delete-and-lifecycle |
04-transactions-basics |
software | healthy | lessons/02-changing-data/04-transactions-basics |
03-upsert |
software | healthy | lessons/02-changing-data/03-upsert |
scripts |
software | healthy | scripts |
components |
software | healthy | components |
badge |
software | healthy | components/badge |
lesson |
software | healthy | components/lesson |
shell |
software | healthy | components/shell |
app |
software | healthy | app |
badge |
software | healthy | app/badge |
[token] |
software | healthy | app/badge/[token] |
lessons |
software | healthy | app/lessons |
[slug] |
software | healthy | app/lessons/[slug] |
api |
software | healthy | app/api |
lessons |
software | healthy | app/api/lessons |
[slug] |
software | healthy | app/api/lessons/[slug] |
reset |
software | healthy | app/api/lessons/[slug]/reset |
query |
software | healthy | app/api/lessons/[slug]/query |
checks |
software | healthy | app/api/lessons/[slug]/checks |
[checkId] |
software | healthy | app/api/lessons/[slug]/checks/[checkId] |
auth |
software | healthy | app/api/auth |
[...all] |
software | healthy | app/api/auth/[...all] |
cron |
software | healthy | app/api/cron |
cleanup-branches |
software | healthy | app/api/cron/cleanup-branches |
lib |
software | healthy | lib |
shell |
software | healthy | lib/shell |
.claude |
software | healthy | .claude |
Showing first 50 of this kind. Full payload available via the JSON button at the top of the page.
| Label | Layer | Status | Path |
|---|---|---|---|
customers |
data | healthy | lessons/03-combining-tables/04-subqueries/seed.sql |
orders |
data | healthy | lessons/03-combining-tables/04-subqueries/seed.sql |
departments |
data | healthy | lessons/03-combining-tables/02-advanced-joins/seed.sql |
employees |
data | healthy | lessons/03-combining-tables/02-advanced-joins/seed.sql |
shirt_sizes |
data | healthy | lessons/03-combining-tables/02-advanced-joins/seed.sql |
shirt_colors |
data | healthy | lessons/03-combining-tables/02-advanced-joins/seed.sql |
newsletter_subscribers |
data | healthy | lessons/03-combining-tables/03-set-operations/seed.sql |
webinar_attendees |
data | healthy | lessons/03-combining-tables/03-set-operations/seed.sql |
categories |
data | healthy | lessons/03-combining-tables/01-joins/seed.sql |
users |
data | healthy | lessons/03-combining-tables/01-joins/seed.sql |
talks |
data | healthy | lessons/04-schema-and-modeling/02-dates-and-times/seed.sql |
products |
data | healthy | lessons/04-schema-and-modeling/04-ddl-and-schemas/seed.sql |
accounts |
data | healthy | lessons/04-schema-and-modeling/03-constraints/seed.sql |
transactions |
data | healthy | lessons/04-schema-and-modeling/03-constraints/seed.sql |
orders_flat |
data | healthy | lessons/04-schema-and-modeling/05-normalization/seed.sql |
tickets |
data | healthy | lessons/05-intermediate-querying/01-conditional-expressions… |
artists |
data | healthy | lessons/05-intermediate-querying/02-cte/seed.sql |
tracks |
data | healthy | lessons/05-intermediate-querying/02-cte/seed.sql |
plays |
data | healthy | lessons/05-intermediate-querying/02-cte/seed.sql |
articles |
data | healthy | lessons/01-query-fundamentals/03-sorting-and-pagination/see… |
archived_users |
data | healthy | lessons/02-changing-data/02-delete-and-lifecycle/seed.sql |
page_views |
data | healthy | lessons/02-changing-data/03-upsert/seed.sql |
tags |
data | healthy | lessons/02-changing-data/03-upsert/seed.sql |
account |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
lesson_progress |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
session |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
user |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
user_branch |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
verification |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
badge_share |
data | healthy | db/migrations/0003_wealthy_kabuki.sql |
| Label | Layer | Status | Path |
|---|---|---|---|
7.59.4.07 |
network | healthy | app/sign-in-button.tsx |
1.23.82.72 |
network | healthy | app/sign-in-button.tsx |
2.33.66.07 |
network | healthy | app/sign-in-button.tsx |
2.2.82.64 |
network | healthy | app/sign-in-button.tsx |
2.12.51.56 |
network | healthy | app/sign-in-button.tsx |
3.95.29.25 |
network | healthy | app/sign-in-button.tsx |
21.15.46.55 |
network | healthy | app/sign-in-button.tsx |
| Label | Layer | Status | Path |
|---|---|---|---|
postgres |
data | healthy | README.md |
mongodb |
data | healthy | package-lock.json |
sqlite |
data | healthy | package-lock.json |
redis |
data | healthy | package-lock.json |
postgresql |
data | healthy | .env.example |
| Label | Layer | Status | Path |
|---|---|---|---|
0000_typical_vance_astro.sql |
data | healthy | db/migrations/0000_typical_vance_astro.sql |
0002_slippery_talos.sql |
data | healthy | db/migrations/0002_slippery_talos.sql |
0001_red_miek.sql |
data | healthy | db/migrations/0001_red_miek.sql |
0003_wealthy_kabuki.sql |
data | healthy | db/migrations/0003_wealthy_kabuki.sql |
| Label | Layer | Status | Path |
|---|---|---|---|
NotFound |
frontend | healthy | app/not-found.tsx |
Home |
frontend | healthy | app/page.tsx |
RootLayout |
frontend | healthy | app/layout.tsx |
Loading |
frontend | healthy | app/lessons/[slug]/loading.tsx |
| Label | Layer | Status | Path |
|---|---|---|---|
auth::components/lesson/RestoreScroll.tsx |
security | healthy | components/lesson/RestoreScroll.tsx |
auth::.env.example |
security | healthy | .env.example |
auth::app/sign-in-button.tsx |
security | healthy | app/sign-in-button.tsx |
auth::lib/auth.ts |
security | healthy | lib/auth.ts |
| Label | Layer | Status | Path |
|---|---|---|---|
Readline |
software | healthy | components/shell/readline.ts:Readline |
XataApiError |
software | healthy | lib/xata-rest.ts:XataApiError |
RateLimitError |
software | healthy | lib/rate-limit.ts:RateLimitError |
| Label | Layer | Status | Path |
|---|---|---|---|
XATA_API_KEY |
cicd | healthy | — |
XATA_ORG_ID |
cicd | healthy | — |
XATA_MAIN_PROJECT_ID |
cicd | healthy | — |
| Label | Layer | Status | Path |
|---|---|---|---|
gha::ci |
cicd | healthy | .github/workflows/ci.yml |
gha::cleanup-preview |
cicd | healthy | .github/workflows/cleanup-preview.yml |
| Label | Layer | Status | Path |
|---|---|---|---|
check |
cicd | healthy | .github/workflows/ci.yml |
cleanup |
cicd | healthy | .github/workflows/cleanup-preview.yml |
| Label | Layer | Status | Path |
|---|---|---|---|
repobility-clone-aoyedwj3 |
software | healthy | /tmp/repobility-clone-aoyedwj3 |
| Label | Layer | Status | Path |
|---|---|---|---|
vps::aws |
hardware | healthy | package-lock.json |
This page is publicly accessible at:
https://repobility.com/scan/04259378-1d14-4fd4-8f45-bc32b76e7a7a/
To check status programmatically (no auth required):
curl -s https://repobility.com/api/v1/public/scan/04259378-1d14-4fd4-8f45-bc32b76e7a7a/Important — please don't re-submit the same URL repeatedly. The submission endpoint is idempotent: re-submitting the same git URL returns this same scan_token, not a new one. To re-scan this repo, sign up free and use the dashboard.