Sapporta
TypeScript framework for building custom database applications and internal tools with auto-generated spreadsheet-grade data grids.
🔗 Visit Sapporta
Description
Most teams that need an internal tool — a case tracker, an inspection log, a mini-CRM — end up choosing between two bad options: wrestle a generic spreadsheet into something it was never built for, or spend weeks hand-coding a CRUD app just to get a table with filtering and search. Sapporta exists for the middle ground: point it at your data model and it builds you a real, fast, keyboard-friendly data grid for every table automatically, so you write the parts that are actually specific to your business and skip the parts that are the same in every internal tool ever built.
Sapporta is an open-source TypeScript framework (Node.js, Hono, Drizzle ORM, React 19, TanStack Query/Form, Tailwind CSS) for building custom database applications aimed at power users and operations teams. Every table gets an auto-generated spreadsheet-grade grid with filtering, sorting, full-text search, CSV export, and keyboard navigation out of the box. It ships row-level security and permission rules (via CASL), reporting with drill-down, and auto-generated OpenAPI endpoints so AI agents can call your app's data directly. Typical targets: internal CRMs, inspection systems, case trackers, and vertical SaaS built on structured relational data. MIT-licensed, self-hosted via Docker, no paid tier.
💬 Our review
The short version: if you keep rebuilding the same admin-panel-with-a-data-grid for every internal project, Sapporta gives you that grid for free and lets you spend your time on the 10% that's actually unique to your business — and since it's MIT-licensed and self-hosted, there's no seat-based bill waiting for you down the line.
The obvious comparison is Retool or Supabase's auto-generated admin UI: Retool is polished and hosted but bills per user and locks you into its platform; Supabase gives you instant CRUD screens on Postgres but isn't really a framework for building a full custom app around your data. Sapporta sits between the two — you own the code, you own the database, and the grid is generated but the app logic is yours to write. The tradeoff is that you're adopting a fairly opinionated TypeScript stack (Hono, Drizzle, TanStack), so it fits teams already comfortable in that world far better than teams wanting a no-code drag-and-drop builder. Worth it if you build internal tools regularly and are tired of reimplementing the same table; skip it if you want something non-developers can configure without touching code. <!-- ai-generated -->
💰 Pricing
📊 Global score
🤖 AI-enriched data
Open source (MIT), auto-hébergé, aucun coût de licence
Pros
grille de données auto-générée pour chaque table (filtrage, tri, recherche, export CSV)
stack TypeScript moderne (Hono, Drizzle ORM, React 19, TanStack)
sécurité au niveau ligne + permissions via CASL
endpoints OpenAPI auto-générés, prêts pour intégration agents IA
open source MIT, auto-hébergé, zéro coût récurrent
Cons
nécessite une équipe à l'aise avec le stack TypeScript choisi (pas no-code)
pas d'offre hébergée clé en main, il faut gérer son propre déploiement
projet jeune, écosystème de plugins/communauté encore limité