sqlite
AI Text2SQL Tool for Easy Database Management.
🔥🔥🔥 AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
Knex.js is a batteries-included SQL query builder for JavaScript.
Knex.js (pronounced /kəˈnɛks/) is a "batteries included" SQL query builder for PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use.
Embeddable, replicated and fault-tolerant SQL engine.
Dqlite is a fast, embedded, persistent SQL database with Raft consensus that is perfect for fault-tolerant IoT and Edge devices.
Related contents:
Talk to your databases. database client for developers.
A fast, beautiful client for PostgreSQL, SQLite, Redis & ClickHouse. Browse data, run SQL, visualize schemas — or just describe what you need and let AI write the query.
Open-source database client for PostgreSQL, MySQL/MariaDB and SQLite with SQL notebooks, visual EXPLAIN, AI and MCP built in. Hackable with plugins.
Tabularis is an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, and SQLite, with a built-in MCP server so Claude, Cursor, and Windsurf can read your schema and run queries through the same app you already use.
A PostgreSQL protocol adapter for SQLite databases. This project allows PostgreSQL clients to connect to and query SQLite databases using the PostgreSQL wire protocol.
An in-process reimplementation of PostgreSQL, backed by a SQLite-compatible storage engine.
pgmicro is built as an experimental fork of Turso — a full from-scratch rewrite of SQLite in Rust — with PostgreSQL added as a native dialect. The result is a fast, embeddable, single-file database that speaks PostgreSQL.
The database client Mac deserves. Fast, native database client for Mac
Connect to MySQL, Postgres, SQLite, Mongo, Redis, and a dozen more. Built with SwiftUI. Ships under 50 MB. Launches in under a second.
Related contents:
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server.
sqldef is a CLI tool for diffing two SQL schemas. You can use it to manage the migration of RDBMSs using regular SQL DDLs.
Supported databases: MySQL, MariaDB, TiDB, PostgreSQL, SQL Server, and SQLite3.
Minimal Database MCP Server.
DBHub is a zero-dependency, token efficient MCP server implementing the Model Context Protocol server interface. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases.
🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite.
SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, Postgres and SQLite behind a common interface that aligns their behaviour where appropriate. MS SQL Server Support is available under SeaORM X.
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL and SQLite, Turso and more.
The lazygit of SQL databases. Connect to Postgres, MySQL, SQL Server, SQLite, Supabase, Turso, and more from your terminal in seconds.
Related contents:
An open-source SQL-Native memory engine for AI. Open-Source Memory Engine for LLMs, AI Agents & Multi-Agent Systems.
One line of code to give any LLM persistent, queryable memory using standard SQL databases.
Memori enables any LLM to remember conversations, learn from interactions, and maintain context across sessions with a single line: memori.enable(). Memory is stored in standard SQL databases (SQLite, PostgreSQL, MySQL) that you fully own and control.
SQL & noSQL database manager.
Powerful and easy to use (no)SQL database client for MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB, Redis, …
DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import.
🗄 CLI tool for backup your databases, files to cloud storages in schedully.
GoBackup is a backup tool design for application servers, to backup your databases, files to cloud storages (FTP, SCP, S3, GCS, Aliyun OSS ...) in schedully.
Related contents:
Streaming SQLite Replication.
Stop building slow, complex, fragile software systems. Safely run your application on a single server.
Litestream is a standalone disaster recovery tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database.
Related contents:
Smart Edge Databases with Cloud Sync and Intelligence.
SQLiteSync is a local-first SQLite extension using CRDTs for seamless, conflict-free data sync and real-time collaboration across devices.
Related contents:
A fast, lightweight replacement for SwiftData, powered by SQL and supporting CloudKit synchronization.
The best SQLite database editor for macOS
Base is a small, powerful, comfortable SQLite editor for everyone
WebAssembly SQLite with support for browser storage extensions.
This is a WebAssembly build of SQLite with support for writing SQLite virtual filesystems completely in Javascript. This allows alternative browser storage options such as IndexedDB and Origin Private File System. Applications can opt to use either a synchronous or asynchronous (using Asyncify or JSPI) SQLite library build (an asynchronous build is required for asynchronous extensions).
Related contents:
🛡️A resilient, high-performance asynchronous connection pool layer for SQLite, designed for efficient and scalable database operations.
Write it Down. Own it Forever.
A clean, quiet space to think. Your notes live in standard Markdown within a local SQLite database. No vendor lock-in, no distractions. Selfhosted notes app. Single golang binary, notes stored as markdown within SQLite, full-text search, very low resource usage
Create custom SQLite functions in JavaScript. Extend your database with scalars, aggregates, window functions, and collations directly in JavaScript.
SQLite-JS is a powerful extension that brings JavaScript capabilities to SQLite. With this extension, you can create custom SQLite functions, aggregates, window functions, and collation sequences using JavaScript code, allowing for flexible and powerful data manipulation directly within your SQLite database.
Local-first data layer for high-performance apps. LiveStore is a next-generation state management framework based on reactive SQLite and git-inspired syncing (via event-sourcing).
LiveStore is a fully-featured, client-centric data layer (replacing libraries like Redux, MobX, etc.) with a reactive embedded SQLite database powered by real-time sync (via event-sourcing).
LumoSQL is a modification (not a fork) of the SQLite embedded data storage library, which is among the most-deployed software. LumoSQL adds security, privacy, performance and measurement features to SQLite.
Index your Gmail account to a SQLite DB and play with the data.
This is a script to download emails from Gmail and store them in a SQLite database for further analysis. I find it extremely useful to have all my emails in a database to run queries on them. For example, I can find out how many emails I received per sender, which emails take the most space, and which emails from which sender I never read.
SQLite Multitenancy With Rails.
Related contents:
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information...
Related contents:
- SQLite File Format Viewer.
- SQLite Transactions and Virtual Tables @ Misframe.
- A faster way to copy SQLite databases between computers @, alexwlchan.
- Scaling SQLite to 4M QPS on a single server (EC2 vs Bare Metal) @ Expensify.
- PSA: SQLite WAL checksums fail silently and may lose data @ blag.
- Lessons learned from building a sync-engine and reactivity system with SQLite @ Antoine's blog.
- From 19k to 4.2M events/sec: story of a SQLite query optimisation @ mnt.io.
- SQLite Is ULTIMATE Choice For 99% of Projects @ DevOps Toolbox's YouTube.
- Subtleties of SQLite Indexes @ Evan Schwartz.
- SQLite concurrency and why you should care about it @ Jellyfin.
- 100000 TPS over a billion rows: the unreasonable effectiveness of SQLite @ anders murphy.
- The Silent Standard: Why the World’s Most Deployed Database Is Killing the Custom File Format @ WebProNews.
- SQLite JSON Superpower: Virtual Columns + Indexing @ DB Pro.
- I don't buy SQLite in the cloud @ Monroe Clinton.
- SQLite 3.52 Released With WAL Corruption Fix and CLI Improvements @ linuxiac.
- Gotchas with SQLite in Production @ Anže's Blog.
- Modern SQLite: Features You Didn’t Know It Had @ slicker.me.
- SQLite is All You Need for Durable Workflows @ Obelisk.
- SQLite improving performance with pre-sort @ anders murphy.
- Detecting Full Table Scans With SQLite @ Tenderlove Making.
- SQLite should have (Rust-style) editions @ Mort's Ramblings.
This tool helps you explore the SQLite file format internals according to the official specification. It's designed for developers and database enthusiasts who want to understand the internal structure of SQLite database files.
Distributed SQLite.
LiteFS is a distributed file system that transparently replicates SQLite databases. You can run your application like it’s running against a local on-disk SQLite database but behind the scenes the database is replicated to all the nodes in your cluster. With LiteFS, you can run your database right next to your application on the edge. You can run LiteFS anywhere!
Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.
Python scripts for parsing health data into and manipulating data in a SQLite database. SQLite is a light weight database that doesn't require a server.
Related contents:
Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them. A small GUI application built in redbean that lets you explore your SQLite databases "page by page" the way SQLite sees them.
The lightweight, user-friendly, distributed relational database built on SQLite. Fault tolerance and high availability with zero hassle.
Related contents:
Open Source Airtable Alternative & Backend as a Service. 🚀 Private first self-hosted no code database & BaaS.
UNDB is a no-code platform that can also serve as a Backend as a Service (BaaS). It is based on SQLite and can be packaged into a binary file using Bun for backend service. Additionally, it can be deployed as a service via Docker, offering a UI for table management.
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
Self-hosted street address database
A SQLite3 database file with over 150 million U.S. and Canada address records. Indexed for fast queries, even on fairly slow hardware.
Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.
Related contents:
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it makes sense.
An embedded database. the champagne of beta embedded databases.
Database schema diagrams visualizer. Open-source database diagrams editor.
Free and open-source database diagrams editor, visualize and design your DB with a single query.
ChartDB is a powerful, web-based database diagramming editor. Instantly visualize your database schema with a single "Smart Query." Customize diagrams, export SQL scripts, and access all features—no account required. Experience seamless database design here.
A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB & Elastic Search with Chat interface.
Modern, Native Tool for Database Management. Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more
SQLite on the edge.
HTTP SQLite scale-to-zero database on the edge built on Cloudflare Durable Objects. Open source, scale-to-zero, HTTP SQLite database built on top of Cloudflare Durable Objects.
Feature-rich ORM for modern TypeScript & JavaScript.
Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more.
FerretDB allows you to use MongoDB drivers seamlessly with PostgreSQL as the database backend. Use all tools, drivers, UIs, and the same query language and stay open-source.
An SQLite based, PHP-only fulltext search engine.
A full text search engine with tokenization, stemming, typo tolerance, filters and geo support based on only PHP and SQLite.
The database client every command line junkie deserves.
Interactive client for PostgreSQL, MySQL, SQLite3, Oracle and SQL Server.
Build Databases As Spreadsheets :No-Coding Required.
NocoDB allows building no-code database solutions with ease of spreadsheets. Bring your own database or choose ours! Millions of rows? Not a problem. Your Data. Your rules. You are in control.
🔥 🔥 🔥 Open Source Airtable Alternative. Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart spreadsheet.
A vector search SQLite extension that runs anywhere!
Nmap Dashboard Mini Project.
nmap-did-what is a Grafana docker container and a Python script to parse Nmap XML output to an SQLite database. The SQLite database is used as a datasource within Grafana to view the Nmap scan details in a dashboard.
Redis re-implemented with SQLite.
Redka aims to reimplement the good parts of Redis with SQLite, while remaining compatible with Redis API.
Related contents:
A set of extensions to Doctrine 2 that add support for functions available in MySQL, Oracle, PostgreSQL and SQLite.
MariaDB, MySQL, MSSQL, PostgreSQL and SQLite made easy.
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide.
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.
Related contents:
SQLite for modern applications.libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
libSQL is an open source, open contribution fork of SQLite, created and maintained by Turso. We aim to evolve it to suit many more use cases than SQLite was originally designed for, and plan to use third-party OSS code wherever it makes sense.