{"repo":"idea-garage/supatool","free":true,"listed":false,"github":"https://github.com/idea-garage/supatool","clone":"git clone https://github.com/idea-garage/supatool.git","description":"CLI for PostgreSQL schema management — extract, deploy diffs, apply migrations. Works with Google Cloud SQL, Supabase, and any PostgreSQL DB.","language":"TypeScript","stars":27,"topics":["cli","cloud-sql","database","migration","postgresql","schema","supabase","typescript"],"license":"MIT","category":"databases-storage","readme_excerpt":"Supatool Schema Management CLI for PostgreSQL. Works with Cloud SQL, Supabase, and any PostgreSQL database. Extract schemas into LLM-friendly structures, deploy diffs, apply migrations, and export seeds. Why Supatool? Modern AI coding tools (Cursor, Claude, MCP) often struggle with large database schemas. Typical issues include: - Token Waste: Reading the entire schema at once consumes 10k+ tokens. - Lost Context: Frequent API calls to fetch table details lead to fragmented reasoning. - Inaccuracy: AI misses RLS policies or complex FK relations split across multiple files. Supatool solves this by reorganizing your schema into a highly searchable, indexed, and modular structure that helps AI \"understand\" your DB with minimal tokens. --- Supported Databases Any PostgreSQL database: - Google Cloud SQL (PostgreSQL) - Supabase - Amazon RDS (PostgreSQL) - Self-hosted PostgreSQL Connection strings in both postgresql:// and postgres:// formats are accepted. --- Key Features - Extract (AI-Optimized) – DDL, RLS, and Triggers are bundled into one file per table . AI gets the full picture of a table by opening just one file. - llms.txt Catalog – Automatically generates a standard llms.txt listing all OBJECTS, RELATIONS (FKs), and RPC dependencies. This serves as the \"Map\" for AI agents. - Multi-Schema Support – Group objects by schema (e.g., public , agent , auth ) with proper schema-qualification in SQL. - Migrate – Apply pending db/migrations/ .sql files to remote, with tracking and tr","default_branch":null,"files":null,"tree":[],"storefront":"/r/idea-garage","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/idea-garage/supatool/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."}