Dev tools · alternatives · 2026
24 alternatives to Facata – Connect to SQL Databases from Python
Python DBAPI simplified. Contribute to tlocke/facata development by creating an account on GitHub.
Facata is a Python library that enables developers to connect to and interact with SQL databases. It provides tools for executing queries and managing database connections directly from Python code. The project is… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. Facata – Connect to SQL Databases from Python launched in 2021; newer entries below may have overtaken it.
- 1
I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.
2023 · github.com · its alternatives →
- 2
PugSQL is a Python library for interacting with your database the way the gods intended.
2019 · pugsql.org · its alternatives →
- 3
A SQL database implemented purely in TypeScript type annotations. - codemix/ts-sql
2020 · github.com · its alternatives →
- 4
A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.
2023 · github.com · its alternatives →
- 5
I created this ORM to fill a gap in the Python ecosystem. Due to the nature of typing in Python there are no other Python ORMs that can provide correct type hints. Prisma Python manages to work around this by auto-generating python types. Aside from static type checking, providing type hints means that you will get autocomplete suggestions for you which for me is the killer feature for this ORM (see the GIF in the README for an example). It's also built on top of Prisma, a next-generation ORM for TypeScript which means that the core query building and connection handling has been battle…
2022 · github.com · its alternatives →
- 6
- 7
PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat
2022 · github.com · its alternatives →
- 8
This is a simple graph database in SQLite, inspired by "SQLite as a document database" - dpapathanasiou/simple-graph
2020 · github.com · its alternatives →
- 9
A flexible GraphQL client and server library that can be used to power realtime applications. - tjmehta/primus-graphql
2018 · github.com · its alternatives →
- 10
Contribute to akdor1154/python-csql development by creating an account on GitHub.
2020 · github.com · its alternatives →
- 11
Lightweight text-based SQL parameter binds. Contribute to baverman/sqlbind development by creating an account on GitHub.
2024 · github.com · its alternatives →
- 12
sql-tap is a transparent proxy that captures SQL queries by parsing the PostgreSQL/MySQL wire protocol and displays them in a terminal UI. You can run EXPLAIN on any captured query. No application code changes needed — just change the port.
Feb 2026 · github.com · its alternatives →
- 13HA
Hi all, we recently open sourced the first version of Hashquery, a Python library which lets you model analytics, DRY up common logic, and execute it against a database or warehouse. We were originally rendering SQL directly for all our queries, but that spiraled out of control with more complex analysis; the SQL needed to be changed sporadically for each new database dialect (BigQuery, Redshift, Aethena, Postgres, etc etc) and the SQL fragments were very challenging to reuse (and so fragments were copy-pasted all over). ~~~ Advantages we think it has over writing SQL by hand: - Queries are…
2024 · hashquery.dev · its alternatives →
- 14
WunderBase is an open source Serverless GraphQL database built on SQLite, Firecracker, and Prisma. Sleep mode saves cost—perfect for fast, lightweight apps.
2022 · wundergraph.com · its alternatives →
- 15SP
2017 · sultan.readthedocs.io · its alternatives →
- 16
Golang SQLite without cgo. Contribute to cvilsmeier/sqinn-go development by creating an account on GitHub.
2023 · github.com · its alternatives →
- 17
Lua + SQLite + musl libc running on x86. Contribute to ers35/luakernel development by creating an account on GitHub.
2014 · github.com · its alternatives →
- 18
Hello everyone! I'm exited to share a NodeJS package I was working on for the past two months. The package is designed to simplify querying SQL databases through an array-like API. Qustar supports PostgreSQL, SQLite, MySQL, and MariaDB, and offers TypeScript support for a robust development experience. It's in early stage of development. I would like to hear your thoughts about it.
2024 · github.com · its alternatives →
- 19
I work mostly in the terminal but found myself constantly switching to bloated GUIs like SSMS only for the simple task of browsing tables and run queries. And I didn't find Existing SQL TUIs intuitive, having to read documentation to learn keybindings and CLI flags to connect. Given I had recently switched to linux, I found myself using vs code's sql database extension. Something was awfully wrong. I wanted something like lazygit for databases – run it, connect, and query and frankly just make it enjoyable to access data. Sqlit is a keyboard-driven SQL TUI with: - Context-based keybindings…
Dec 2025 · github.com · its alternatives →
- 20
- 21
A lightweight database with Python syntax queries, using ZeroMQ - asrp/pyzdb
2017 · github.com · its alternatives →
- 22DU
Hi! As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite. Reasons: 1) Using an SQL Database meant having less flexibility and iterating slower. 2) Alternative, proven Document Databases only offered client/server support. 3) No network. Having SQLite server-side next to the application is extremely fast. 4) Replicating Firestore's API makes it easy to use. 5) Listeners and real-time…
2023 · npmjs.com · its alternatives →
- 23
"Mongita is to MongoDB as SQLite is to SQL". Contribute to scottrogowski/mongita development by creating an account on GitHub.
2021 · github.com · its alternatives →
- 24
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
2022 · github.com · its alternatives →
Also compare
- I wrote a RDBMS (SQLite clone) from scratch in pure Python alternatives
- PugSQL, a Python Port of HugSQL alternatives
- A SQL database implemented purely in TypeScript type annotations alternatives
- MongoDB Protocol for SQLite alternatives
- Prisma Python – A fully typed ORM for Python alternatives
- Reindeer alternatives
Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →