{"repo":"freenandes/actuallyexplain","free":true,"listed":false,"github":"https://github.com/freenandes/actuallyexplain","clone":"git clone https://github.com/freenandes/actuallyexplain.git","description":"actuallyEXPLAIN is a visualizer that helps you understand logical intent in complex PostgreSQL queries in a diagram and dictionarized form.","language":"TypeScript","stars":81,"topics":["postgresql","sql","ast","dag","developer-tools","visualization","database"],"license":null,"category":"databases-storage","readme_excerpt":"actuallyEXPLAIN actuallyEXPLAIN is a visualizer that helps you understand complex PostgreSQL queries in a diagram and dictionarized form. Paste your code, and check the logic. No database connection required. This may be useful for full-stack developers, indie hackers, and perhaps anyone using AI to write SQL who needs to verify what the code actually does before running it in production. Right now, it just maps the logical intent. In the future, we want to help flag dangerous anti-patterns, warning you about potential database locks, and catching bad queries before they ever execute. Open source under the MIT license. You're welcome to view the code, suggest stuff and contribute. Contributing 1. Fork the repo and clone it 2. npm install then npm run dev to start the local server 3. Make your changes, run npm run build to check for errors 4. Open a pull request Tech - React 19 + TypeScript , bundled with Vite - Monaco Editor — the same editor that powers VS Code, used for SQL input - React Flow — renders the node/edge diagram; layout is computed with dagre - pgsql-ast-parser — parses raw SQL into an AST (no database needed) - Lucide icons - CSS Modules for styling (no UI framework) Codebase All source lives in src/ . Key files: File Role ----------------------- --------------------------------------------------------------- App.tsx Root component — wires together the editor, diagram, and panels buildFlowFromAST.ts Converts the parsed SQL AST into React Flow nodes and edges Sq","default_branch":null,"files":null,"tree":[],"storefront":"/r/freenandes","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/freenandes/actuallyexplain/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}