Featured
S
SuperX
Grow faster on 𝕏. Find viral ideas, understand your audience, refine your content, and accelerate your 𝕏 growth, all in one place.
Visit
Ask AI about shirube
ChatGPT
Claude
Perplexity
GrokS
shirube
Understand your database as a map — with AI as your navigator.
Aug 10, 2026
Maker
Sshoutaro
0
2 upvotes
Product Overview
shirube is an open-source, AI-native database explorer that helps developers understand a database as a map. It automatically visualises PostgreSQL and SQLite schemas as an interactive ER diagram, so relationships and table structure can be explored without manually tracing foreign keys.
The explorer can search for tables, follow relationships one hop at a time, preview data, and answer questions with an optional AI navigator. shirube runs locally in read-only mode and does not send credentials or data through a shirube server.
Key features
- Automatically visualises PostgreSQL and SQLite schemas as an interactive ER diagram
- Search for a table and follow relationships one hop at a time
- Preview data while navigating the schema map
- Optional AI navigator for database questions like connection paths
- Safe by design: runs locally, connects read-only, and does not send credentials or data through a shirube server
- AI navigator supports user-provided Claude or OpenAI keys and local models via Ollama
How shirube works
- 1
Run shirube locally
Start shirube with uvx shirube to launch the local database explorer.
- 2
Connect in read-only mode
Provide a database connection for PostgreSQL or SQLite, with access handled as read-only.
- 3
Explore diagram and ask questions
Use the interactive ER diagram to search tables, follow relationships, preview data, and optionally ask the AI navigator about connections.
Use cases
- A developer onboarding to an unfamiliar PostgreSQL database can quickly locate a table, view its connected entities in an ER diagram, and inspect related data without writing SQL joins.
- A backend engineer debugging a schema change can trace how “customers” connects to “payments” through one-hop relationships and confirm how tables relate before updating application queries.
- A team member working with a local SQLite file can explore table structure, preview sample rows, and use the AI navigator to ask how entities are connected—without uploading database contents to a server.
Who is it for?
shirube is for developers who need to understand PostgreSQL or SQLite schemas during onboarding, debugging, or development. It’s especially useful for teams that want local, read-only database exploration with an optional AI assistant.