davemorin

davemorin / supacrawl

Public

Mirror Supabase/Postgres into local SQLite for search and offline analysis

29
2
100% credibility
Found May 11, 2026 at 30 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Go
AI Summary

supacrawl creates a local copy of your Supabase project's database structure, rules, functions, optional data rows, and storage details for fast offline searching and analysis.

How It Works

1
🔍 Discover supacrawl

You learn about a simple tool that copies your Supabase project's details to your computer for quick offline checking.

2
📥 Prepare the tool

You get supacrawl set up on your machine so it's ready to use.

3
🔗 Connect your project

You link supacrawl to your Supabase project, sharing just the info it needs to access your database shape.

4
✨ Pull down your copy

Supacrawl grabs all the tables, rules, functions, and more into a private local file, feeling fast and complete.

5
🔎 Explore and search

You search for things like security rules or peek at data right on your computer, no internet needed.

6
💾 Save extras

You download files from storage or export tables as simple lists for sharing or backups.

✅ Offline freedom

Now you work with your project's details anytime, anywhere, safely on your own machine.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 30 to 29 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is supacrawl?

Supacrawl is a Go CLI tool that mirrors your Supabase/Postgres database schema, policies, functions, and optionally full table rows into a local SQLite file for offline search and analysis. Set your Supabase DB URL, run `supacrawl sync --full`, and get FTS-powered queries, SQL access, and Storage blob downloads without hitting the dashboard. It's local-first like discrawl, perfect for inspecting RLS policies or exporting JSONL rows on your machine.

Why is it gaining traction?

Full row mirroring stores data as schema-agnostic JSON, enabling diffing archives (`supacrawl diff`), encrypted backups with age, and per-table exports--features rare in Supabase tools. Auto-refresh on reads keeps data fresh within a staleness window, and JSON/CLI outputs suit scripts or agents. At 29 stars, it's niche but hooks devs tired of cloud-only introspection.

Who should use this?

Supabase maintainers auditing policies or schemas offline; teams analyzing Storage inventories without API limits; AI agents querying local snapshots for analysis. Ideal for local dev workflows mirroring Supabase like you'd mirror a GitHub repo to GitLab or Azure DevOps for offline work.

Verdict

Try it for Supabase-heavy projects--solid CLI, tests, and Go build make it reliable despite 1.0% credibility and low stars signaling early maturity. Docs are crisp; pair with Homebrew for quick setup, but watch for edge function support in future releases.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.