# sqlite

Database schema management for modern teams

Database schema management and migration tool by Ariga with a declarative schema-as-code approach. Features automatic migration planning, CI/CD integration, and drift detection to keep database schemas in sync across environments. Supports PostgreSQL, MySQL, MariaDB, and SQLite, making database changes as reviewable and version-controlled as application code.

Promise-based Node.js ORM

Mature, promise-based ORM for Node.js supporting PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server. Features model definitions with validations, eager/lazy loading, transactions, migrations, raw queries, and lifecycle hooks. Supports soft deletes, scopes, and virtual fields. One of the oldest and most battle-tested Node.js ORMs, widely used in enterprise apps though increasingly succeeded by Prisma and Drizzle in new projects.

Open-source SQL editor and DB manager

Self-hosting platform for deploying applications, databases, and services on your own infrastructure. Open-source Heroku and Vercel alternative with Docker-based deployments, automatic SSL, and built-in monitoring. Gives developers full control over their hosting environment with a modern UI, reducing cloud costs while maintaining the convenience of managed platform features.

Modern database management GUI

Native database management GUI for macOS, Windows, and Linux that provides a fast, clean interface for working with PostgreSQL, MySQL, SQLite, SQL Server, Redis, CockroachDB, and more. Features an intuitive query editor with auto-completion, visual table editor for inline data editing, import/export in multiple formats, SSH tunnel support, and connection management. Known for its speed and polished UI compared to heavier tools like DBeaver. Popular among Mac developers.

ORM for TypeScript and JavaScript

Full-featured ORM for TypeScript and JavaScript supporting Active Record and Data Mapper patterns. Works with PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, and MongoDB. Features decorator-based entity definitions, migrations, relations (one-to-one, many-to-many), lazy/eager loading, query builder, transactions, and caching. Supports both Node.js and browser runtimes. 34K+ GitHub stars. Mature but losing mindshare to Prisma and Drizzle for new TypeScript projects.

SQL query builder for Node.js

Flexible SQL query builder for Node.js supporting PostgreSQL, MySQL, SQLite, Oracle, and MSSQL. Chainable API for constructing queries with parameterized bindings. Features schema builder, migration system, seed files, transaction support, and connection pooling. Foundation for ORMs like Bookshelf.js and Objection.js. One of the most established query builders in the Node.js ecosystem.

Type-safe SQL query builder for TS

Type-safe SQL query builder for TypeScript that provides auto-completion and compile-time type checking without the abstraction overhead of a traditional ORM. Write queries that map directly to SQL while getting full TypeScript inference from your database schema. Supports PostgreSQL, MySQL, and SQLite with migrations, transactions, and raw SQL escape hatches. Lightweight with zero dependencies. Ideal for developers who want SQL control with TypeScript safety. Growing Knex.js alternative.

SQLite for production

Edge-hosted distributed database built on libSQL (an open-source fork of SQLite) designed for low-latency data access worldwide. Features multi-region replication, embedded replicas that sync to your application server for microsecond reads, database branching for development workflows, and point-in-time recovery. Ideal for edge computing, serverless functions, and mobile apps. Compatible with SQLite ecosystem tooling. Generous free tier with 9GB storage and 500 databases.

Magical shell history

Shell history manager that replaces the default history with a SQLite-backed, encrypted, and synchronized command history across all your machines. Features full-text search with fuzzy matching, directory-based context filtering, session tracking, and statistics about command usage. Syncs via an encrypted server (self-hostable or hosted). Supports bash, zsh, and fish shells. 22K+ GitHub stars. Transforms shell history from a simple list into a searchable, cross-machine knowledge base.