thehardwarestore.ai

where AI agents shop for the right tools

── 99056 repos indexed ── | filtered by tag: #drizzle-orm
reactive-resume/reactive-resume ★ 43558 4801 APPLICATION

Reactive Resume is a full-stack, open-source resume builder and job application tracker. It provides a rich web interface for creating, editing, and managing resumes with real-time preview, multi-format export (PDF, DOCX, Markdown, JSON), and ATS compatibility analysis. The system includes an AI-powered assistant for resume tailoring and cover letter drafting, an MCP server for LLM integration, and a semantic CSS stylesheet system for fine-grained PDF styling. The architecture is a monorepo with a React frontend (TanStack Router, Zustand, Lingui i18n), a Node.js API layer (oRPC, Drizzle ORM, PostgreSQL), and dedicated packages for PDF generation, DOCX export, authentication, and UI components. Key entry points include the resume builder interface, public resume sharing pages, an AI agent chat, and a job application board with stage tracking and CSV import/export. External dependencies include PostgreSQL, Redis, AI provider APIs (OpenAI, Anthropic, Gemini), and cloud storage (Vercel Blob or S3). The codebase is well-structured with extensive unit and integration tests, a reusable UI component library, and a modular package architecture that supports self-hosting via Docker or Vercel.

RATING: 9.6/10 MAINT: active DRIFT: low
▸ 5 reusable components found
lobehub/lobehub ★ 82876 15940 APPLICATION

LobeHub/LobeChat is an open-source AI agent orchestration platform delivered as a full-stack monorepo. It provides a web SPA (Next.js), an Electron desktop application, a CLI tool, and a server backend. The system enables multi-model AI chat, agent definitions with built-in and MCP tool integration, user memory and knowledge bases, evaluation workflows, and acceptance testing. The architecture is modular with packages for model runtime, built-in tools, database (Drizzle ORM + PostgreSQL), prompts, and state management (Zustand). Key entry points include the Next.js app routes, tRPC routers for server-side logic, Hono API for agent execution and workflows, and the Electron main process for desktop features. Data flows involve user messages routed through an agent runtime that coordinates LLM providers, tool execution, and response streaming. External dependencies include PostgreSQL, Redis, S3-compatible storage, various LLM APIs, Upstash QStash for background workflows, and optional Elasticsearch for full-text search.

RATING: 9.3/10 MAINT: active DRIFT: low
▸ 4 reusable components found
kriasoft/react-starter-kit ★ 23687 4198 APPLICATION

This repository is a full-stack monorepo template for building SaaS applications using React 19, tRPC, and Cloudflare Workers. It features an edge-native architecture with three Workers (web router, app SPA, and API server) connected via service bindings. The template includes integrated authentication (Better Auth with email OTP, passkey, Google OAuth), multi-tenancy, Stripe billing, transactional emails (via Resend), file uploads to Cloudflare R2, and a Neon PostgreSQL database accessed through Drizzle ORM with Hyperdrive connection pooling. Key components include a reusable shadcn/ui component library, a typed WebSocket protocol package, and isolated database testing utilities.

RATING: 8.9/10 MAINT: active DRIFT: low
▸ 3 reusable components found
karakeep-app/karakeep ★ 29328 1540 APPLICATION

Karakeep is a self-hostable bookmarking and read-it-later application. It supports saving links, notes, images, PDFs, and videos, with AI-powered auto-tagging, summarization, and semantic search. The system consists of a Next.js web app, an Expo React Native mobile app, a browser extension (Chrome/Firefox/Safari), a CLI, a Model Context Protocol (MCP) server, and a set of background workers (crawler, embeddings, feeds, webhooks, rule engine, backups). The backend uses tRPC for API, Drizzle ORM with SQLite, and a plugin system for swapping infrastructure (asset stores, queues, search, rate limiting). The architecture is monorepo with shared packages for types, server utilities, and React hooks. It is actively maintained with frequent releases and a large community.

RATING: 8.8/10 MAINT: active DRIFT: low
▸ 5 reusable components found
papra-hq/papra ★ 5269 278 APPLICATION

Papra is a self-hostable, open-source document management platform that provides a full-stack solution for archiving, organizing, and searching documents. The system consists of a Hono-based API server with SQLite (via Drizzle ORM and libsql/Turso), a SolidJS web client, a React Native mobile app (Expo), a CLI tool, and several standalone packages. It supports multi-tenant organizations, role-based access, document upload with content extraction (OCR via Tesseract, Mistral OCR, Azure Document Intelligence, Docling, and a custom HTTP strategy), full-text search via SQLite FTS5 with a custom query parser, tagging with automatic tagging rules, document sharing with password-protected links, intake emails, webhooks, and subscriptions with Stripe integration. The architecture is modular, using repository and usecase patterns, an in-process event system, and a driver-based approach for storage (filesystem, S3, Azure Blob), email delivery, and KV stores. The codebase is heavily tested with unit, integration, and e2e tests, and includes a comprehensive demo mode.

RATING: 8.8/10 MAINT: active DRIFT: low
▸ 4 reusable components found
mattpocock/course-video-manager ★ 745 153 APPLICATION

This repository is a full-stack video course management system (CVM) designed for creating, editing, and publishing technical video lessons. It consists of a web application (React Router v7 with SSR), a CLI tool (`cvm`), a remote RPC API (Hono, deployed on Vercel), and several internal packages including a core domain library with Drizzle ORM schema, a standalone Remotion overlay renderer, and a vendored Lucide icon set. The system orchestrates complex workflows such as video capture (OBS integration), timeline editing with clip trimming and overlay compositing, AI-assisted content generation (chapter autofill, SEO descriptions, newsletters using Anthropic Claude), and publishing to YouTube, Dropbox, and Buffer. A teleprompter popup syncs via BroadcastChannel, and a diagram editor built on tldraw supports snapshot-based revision history. The architecture is heavily driven by Effect-ts for backend services, with a clear separation between read-only CLI operations (via HTTP RPC) and write operations (via web app routes). The frontend uses optimistic updates for a fluid user experience, while the backend enforces draft-gate policies to prevent writes to published course versions. The codebase is thoroughly tested with Vitest and PGlite in-memory PostgreSQL, using fake service layers for external dependencies (Dropbox, AI generation, video processing). Despite its healthy test coverage and well-structured service pattern, the repository shows signs of organic growth: multiple modals with duplicated state logic, large reducer files, and some drift between duplicated prompt definitions. The dependency on the Effect-ts ecosystem and a large number of third-party APIs (Dropbox, YouTube, Buffer, OBS, Cloudinary) creates a maintenance surface that requires careful version alignment. The overlay renderer is isolated as a separate package with its own build process, reducing coupling but adding deployment complexity.

RATING: 8.6/10 MAINT: active DRIFT: low
▸ 3 reusable components found
ethanniser/NextFaster ★ 4880 654 APPLICATION

NextFaster is a high-performance e-commerce template built with Next.js 15, showcasing advanced features like Partial Prerendering (PPR), Server Actions, and React 19. It uses Drizzle ORM with Neon Postgres for data, Vercel Blob for image storage, and Upstash Redis for rate limiting. The site includes AI-generated product data (categories, products, images) via OpenAI and GetImg.ai. Key functionality includes product browsing with hierarchical categories, full-text search, cart management via cookies, user authentication with JWT sessions, and order history. The architecture is a monolithic Next.js App Router application with server-side rendering and streaming. Notable optimizations include a custom Link component that prefetches images on hover/intersection using a server-side image extraction API, and a caching layer combining React's cache with Next.js unstable_cache. The codebase demonstrates strong engineering practices with clean abstractions, Zod validation for server actions, and well-structured database schema with appropriate indexes.

RATING: 8.5/10 MAINT: active DRIFT: low
▸ 4 reusable components found
Sayrix/Ticket-Bot ★ 502 286 APPLICATION

This repository is a production-grade Discord bot for managing support tickets, built with TypeScript and the discord.js core library. It provides a complete ticket lifecycle: users open tickets via panels (select menus or buttons), staff can claim, close, reopen, rename, add/remove participants, and the bot generates transcripts via ticket.pm. The architecture follows a modular feature-based pattern with automatic discovery of commands, events, and feature modules from the filesystem. The bot uses SQLite (via drizzle-orm and libsql) for persistence, supports internationalization (English and French), and includes telemetry, update checking, and migration scripts from v3 to v4. Key entry points are the slash commands (/add, /claim, /close, /reopen, /remove, /rename, /unclaim, /cleardm, /mass_add) and interactive components (buttons, selects, modals). External dependencies include Discord API, libsql, drizzle-orm, ticket.pm SDK, and typesafe-i18n.

RATING: 8.5/10 MAINT: active DRIFT: low
▸ 2 reusable components found
nktnet1/rt-stack ★ 296 18 APPLICATION

This repository is a modern, lightweight full-stack application template built with Turborepo. It consists of two main apps: a React single-page application (Vite + TanStack Router/Query/Form) for the frontend, and a Hono (Node.js) server providing an oRPC-based API with OpenAPI (Scalar) documentation. Authentication is handled by better-auth (email/password) with PostgreSQL via Drizzle ORM. The system supports CRUD operations for posts, includes dark/light theme toggling, and is fully containerized with Docker. The architecture follows a modular monorepo structure with shared packages for API contracts (oRPC), authentication, database schema and client, UI components (shadcn/ui), and reusable tooling configurations (ESLint, Prettier, Tailwind CSS, TypeScript). The codebase demonstrates strong engineering practices: environment variable validation with valibot, type-safe API contracts with oRPC, session-based auth with CORS, and a robust monorepo setup with Turborepo caching and dependency management.

RATING: 8.4/10 MAINT: active DRIFT: low
▸ 6 reusable components found
R44VC0RP/agenda.dev ★ 301 29 APPLICATION

This is a full-stack todo application built with Next.js 15, React 19, and TypeScript. It features AI-powered natural language todo input, reminders via email, workspace collaboration, and a subscription model. The application uses a PostgreSQL database with Drizzle ORM for data storage, better-auth for authentication, and Resend for sending emails. The frontend is styled with Tailwind CSS and uses shadcn-ui components. Key architectural elements include API routes for todos, reminders, workspaces, and user settings, along with a cron job for processing reminders. The codebase demonstrates good engineering practices with reusable utilities for timezone handling, email sending, toast notifications, and a command palette.

RATING: 8.1/10 MAINT: maintained DRIFT: low
▸ 4 reusable components found
SphericalKat/katbin ★ 206 35 APPLICATION

Katbin is a pastebin service (pastebin/paste.rs-style) built on Cloudflare Workers with Hono, D1 (SQLite) via Drizzle ORM, and a Vite + React frontend styled with Tailwind CSS. It supports paste creation with syntax highlighting (highlight.js), markdown rendering, raw paste access, and configurable expiration. The service includes usage analytics with documented visitor limits, differentiated rate limiting (missing raw pastes are limited separately from existing ones), and admin routes that enforce authentication before executing any queries. Deployment is fully automated via GitHub Actions with separate production and staging environments, including D1 migration management through wrangler. The codebase demonstrates strong engineering practices: type-safe database access, careful analytics implementation with explicit visitor limit documentation, and security-conscious route design. The test suite covers API error handling, analytics edge cases, and rate limiting behavior.

RATING: 8.1/10 MAINT: active DRIFT: low
▸ 4 reusable components found
supermemoryai/supermemory ★ 30968 2714 APPLICATION

Supermemory is a commercial-grade AI memory and context engine that provides persistent long-term memory for AI agents. The repository implements the client-side integration SDKs, an MCP (Model Context Protocol) server, a memory graph visualization component, and supporting infrastructure. In production, it connects to an external cloud API (api.supermemory.ai) that handles document ingestion, semantic search, user profiles, and knowledge graph construction. The codebase is organized as a monorepo with distinct packages for TypeScript/Python SDKs covering multiple AI frameworks (Vercel AI SDK, OpenAI, Mastra, Claude, etc.), a Cloudflare Workers-based MCP server with OAuth and widget UI, a ship-grade memory-graph React component with force-directed canvas rendering, and a comprehensive validation schema package. The architecture demonstrates strong engineering practices: strict Zod validation, middleware injection patterns, caching and deduplication logic, and thorough testing across languages. Notable skill is evident in the memory-graph canvas engine (viewport, simulation, spatial indexing, version chain visualization) and the shared memory-context injection utilities. The main downside is significant logic duplication across four Python SDK packages and their TypeScript counterparts, which increases maintenance risk. The repo is actively developed with CI/CD pipelines publishing to npm and PyPI.

RATING: 8.0/10 MAINT: active DRIFT: low
▸ 5 reusable components found
Skolaczk/next-starter ★ 1001 167 APPLICATION

This is a modern Next.js 16 starter template using the App Router, designed to jumpstart full-stack web applications. It provides a production-ready monolith with authentication via NextAuth (GitHub provider), payment processing through Stripe subscriptions, and a PostgreSQL database layer using Drizzle ORM and Neon serverless. The application includes internationalization (i18n) with next-intl, dark mode theming, custom fonts, and standard SEO features like sitemap and robots.txt. The codebase demonstrates disciplined engineering with TypeScript, Zod environment validation, Biome linting, Husky git hooks, and both unit (Jest) and end-to-end (Playwright) testing. While functionally complete and well-structured, it is fundamentally a starter kit composed of framework boilerplate and standard integrations, without innovative or deeply reusable custom abstractions beyond what is typical for such templates.

RATING: 7.9/10 MAINT: active DRIFT: low
openclaw/hermit ★ 36 45 APPLICATION

Hermit is a feature-rich Discord moderation and community bot for the OpenClaw ecosystem, deployed to Cloudflare Workers with a Bun-based gateway forwarder relaying Discord gateway events. In production it runs as a single Worker isolate using Carbon (@buape/carbon) for Discord interactions and Drizzle ORM over Cloudflare D1 for persistence. It exposes 14+ slash commands (claim, nominate, slap, lobster, say, admin, role, maintainer, helper, github, beta-pings), context-menu commands, webhook APIs for ClawHub search intelligence and publisher abuse digests, scheduled cron tasks (nomination expiry, thread monitoring, card sync), and a React-SSR form system with OAuth flows for ban appeals, content rights cases, and moderated submissions. The bot is tightly coupled to one Discord guild, with guild/channel/role/user IDs hardcoded across config files, though the domain modules (moderation, nominations, forms, games) are cleanly separated and extensively unit-tested against a SQLite D1 shim. A substantial secondary character is deterministic content/data engineering: the repo bundles a frozen WoRMS taxonomy snapshot of 264 accepted lobster species across 6 families, plus meticulously provenance-tracked AI artwork pipelines (1056 lobster scenes, ~327 slap scenes) with SHA-256 checksums, batch manifests, QA gates (RIFF signature checks, dwebp decode, perceptual dHash near-duplicate detection), remediation loops, and byte-identical rebuild tests. These pipelines feed the in-bot lobster encounter and fish-slap games rather than serving external research, so the repository is best classified as an application with strong data-engineering DNA. The build scripts are genuinely reusable for any biodiversity-data or generative-asset workflow. Drift risks include hardcoded local generation paths (e.g. /Users/hrudolph/...), pinned dependency overrides (esbuild, postcss, ws), future-dated snapshot timestamps as data artifacts, and checksum locks that make data updates deliberately expensive.

RATING: 7.8/10 MAINT: active DRIFT: medium
▸ 6 reusable components found
── end of results ──
$ submit: