Showing 378 open source projects for "sql tools python"

View related business solutions
  • Our Free Plans just got better! | Auth0 Icon
    Our Free Plans just got better! | Auth0

    With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

    You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
    Try free now
  • Context for your AI agents Icon
    Context for your AI agents

    Crawl websites, sync to vector databases, and power RAG applications. Pre-built integrations for LLM pipelines and AI assistants.

    Build data pipelines that feed your AI models and agents without managing infrastructure. Crawl any website, transform content, and push directly to your preferred vector store. Use 10,000+ tools for RAG applications, AI assistants, and real-time knowledge bases. Monitor site changes, trigger workflows on new data, and keep your AIs fed with fresh, structured information. Cloud-native, API-first, and free to start until you need to scale.
    Try for free
  • 1
    SQL Explorer

    SQL Explorer

    Easily share data across your company via SQL queries

    ...Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. SQL Explorer is inspired by any number of great query and reporting tools out there.
    Downloads: 9 This Week
    Last Update:
    See Project
  • 2
    SQL Notebook

    SQL Notebook

    SQL Notebook — Casual data exploration in SQL

    SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts.
    Downloads: 8 This Week
    Last Update:
    See Project
  • 3
    Ibis

    Ibis

    Expressive analytics in Python at any scale

    Ibis is a Python library to help you write expressive analytics at any scale, small to large. Its goal is to simplify analytical workflows and make you more productive. Ibis gives you the benefit of a programming language. You don't need to sacrifice maintainability to get to those insights! Ibis builds on top of and works with existing Python tools.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 4
    pgai

    pgai

    A suite of tools to develop RAG, semantic search, and other AI apps

    pgai is a suite of PostgreSQL extensions developed by Timescale to empower developers in building AI applications directly within their databases. It integrates tools for vector storage, advanced indexing, and AI model interactions, facilitating the development of applications like semantic search and Retrieval-Augmented Generation (RAG) without leaving the SQL environment.
    Downloads: 2 This Week
    Last Update:
    See Project
  • Lightspeed golf course management software Icon
    Lightspeed golf course management software

    Lightspeed Golf is all-in-one golf course management software to help courses simplify operations, drive revenue and deliver amazing golf experiences.

    From tee sheet management, point of sale and payment processing to marketing, automation, reporting and more—Lightspeed is built for the pro shop, restaurant, back office, beverage cart and beyond.
    Learn More
  • 5
    athenaSQL

    athenaSQL

    SQL builder for AWS Athena, inspired by sparkSQL

    athenaSQL is Athena SQL query builder, inspired by sparkSQL. It borrow some sparkSQL’s concept sparkSQL. It was initially designed to eliminate the need for hard-coding SQL queries as strings within Python scripts and as an alternative to any bespoke SQL query templating. However, it offers the flexibility to be used in various ways as needed.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 6
    SQLiteStudio

    SQLiteStudio

    A free, open source, multi-platform SQLite database manager

    ...You can execute SQL statements that refer to multiple databases within a single query, thanks to a transparent database attaching mechanism built into the SQL Editor of SQLiteStudio. You can implement your own SQL functions (scalar & aggregate) using JavaScript, Python, or Tcl. There is a repository of ready-to-use scripts on the wiki page.
    Downloads: 223 This Week
    Last Update:
    See Project
  • 7
    SQLAlchemy

    SQLAlchemy

    The Database Toolkit for Python

    SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. An industrial strength ORM, built from the core on the identity map, unit of work, and data mapper patterns.
    Downloads: 26 This Week
    Last Update:
    See Project
  • 8
    HeidiSQL

    HeidiSQL

    A lightweight client for managing MariaDB, MySQL, SQL Server, etc.

    HeidiSQL is a lightweight, open-source client for managing relational databases. It provides a user-friendly interface for browsing and editing data, creating and modifying tables, and executing SQL queries. HeidiSQL supports various database systems, making it a versatile tool for developers and database administrators.
    Downloads: 193 This Week
    Last Update:
    See Project
  • 9
    chDB

    chDB

    chDB is an in-process OLAP SQL Engine

    chDB is an in-process SQL OLAP Engine powered by ClickHouse. It is developed by ClickHouse, Inc and open-source contributors.
    Downloads: 1 This Week
    Last Update:
    See Project
  • Premier Construction Software Icon
    Premier Construction Software

    Premier is a global leader in financial construction ERP software.

    Rated #1 Construction Accounting Software by Forbes Advisor in 2022 & 2023. Our modern SAAS solution is designed to meet the needs of General Contractors, Developers/Owners, Homebuilders & Specialty Contractors.
    Learn More
  • 10
    PGManage

    PGManage

    Web tool for database management

    pgManage is an open-source, cross-platform desktop GUI for managing PostgreSQL databases. It provides a tabbed interface for browsing schemas, writing queries, and managing server configurations. Designed for both developers and DBAs, pgManage aims to be a user-friendly yet powerful alternative to pgAdmin.
    Downloads: 9 This Week
    Last Update:
    See Project
  • 11
    Dbmate

    Dbmate

    A lightweight, framework-agnostic database migration tool

    Dbmate is a database migration tool, to keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool, which can be used with Go, Node.js, Python, Ruby, PHP, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools. Supports MySQL, PostgreSQL, SQLite, and ClickHouse. Uses plain SQL for writing schema migrations. ...
    Downloads: 5 This Week
    Last Update:
    See Project
  • 12
    SQLModel

    SQLModel

    SQL databases in Python, designed for simplicity, compatibility

    SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness. SQLModel is a library for interacting with SQL databases from Python code, with Python objects. It is designed to be intuitive, easy to use, highly compatible, and robust. SQLModel is based on Python-type annotations, and powered by Pydantic and SQLAlchemy.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 13
    Antares

    Antares

    A modern, fast and productivity driven SQL client with a focus in UX

    Antares is a modern, cross-platform SQL client built with Electron and Vue.js. It offers a clean and intuitive UI for managing databases like MySQL, PostgreSQL, SQLite, and more. Designed for developers and DBAs, Antares supports tabbed browsing, query editing with syntax highlighting, and visual schema exploration, making it a powerful alternative to heavier database tools.
    Downloads: 12 This Week
    Last Update:
    See Project
  • 14
    SQL Relay
    Database connection pool with support for lots of languages and databases.
    Leader badge
    Downloads: 23 This Week
    Last Update:
    See Project
  • 15
    pg_probackup

    pg_probackup

    Backup and recovery manager for PostgreSQL

    pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments.
    Downloads: 9 This Week
    Last Update:
    See Project
  • 16
    Jet Database

    Jet Database

    Type safe SQL builder with code generation and automatic query result

    Jet is a complete solution for efficient and high-performance database access, consisting of a type-safe SQL builder with code generation and automatic query result data mapping. Jet currently supports PostgreSQL, MySQL, CockroachDB, MariaDB, and SQLite. Future releases will add support for additional databases.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 17
    Azure Data Studio

    Azure Data Studio

    A data management tool that enables working with other SQL tools

    Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards. Use Azure Data Studio to query, design, and manage your databases and data...
    Downloads: 11 This Week
    Last Update:
    See Project
  • 18
    db

    db

    Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite, etc.

    upper/db is a productive data access layer (DAL) for Go that provides agnostic tools to work with different data sources. Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features. Our agnostic API is compatible with SQL and NoSQL databases. Use the SQL builder or raw SQL statements for advanced cases. An (optional) ORM-like layer is available for all your data modelling needs.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 19
    Django Postgres Extra

    Django Postgres Extra

    Bringing all of PostgreSQL's awesomeness to Django

    django-postgres-extra is a Django extension that enhances PostgreSQL support by adding advanced features like native upserts, materialized view support, and better constraint handling. It improves developer productivity by exposing PostgreSQL-specific capabilities in a Django-friendly way while maintaining ORM consistency.
    Downloads: 5 This Week
    Last Update:
    See Project
  • 20
    Grafana

    Grafana

    Leading open-source visualization and observability platform

    Grafana OSS is a leading open-source visualization and observability platform that lets you query, visualize, alert on, and explore your data—regardless of where it’s stored. With support for 100+ data source plugins (such as Prometheus, Loki, Elasticsearch, InfluxDB, SQL/NoSQL databases, OTel, and more), you can unify metrics, logs, traces, and other observability signals in one place. Grafana OSS empowers you to build dynamic, reusable dashboards with rich visualizations, template...
    Downloads: 19 This Week
    Last Update:
    See Project
  • 21
    Bracket

    Bracket

    Selfhosted tournament system

    Bracket is an open-source tool that tracks and manages data access across your PostgreSQL database. It provides visibility into which parts of your codebase are accessing which tables and columns, enabling data governance, security auditing, and architectural insights. Bracket is particularly helpful for growing teams needing better observability in complex applications.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 22
    usql

    usql

    Universal command-line interface for SQL databases

    usql is a universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases! usql provides a simple way to work with SQL and NoSQL databases via a command-line inspired by PostgreSQL's psql. usql supports most of the core psql features, such as variables, backticks, and commands and has additional features that psql does not, such as syntax highlighting, context-based completion, and multiple database support. ...
    Downloads: 5 This Week
    Last Update:
    See Project
  • 23
    DrawDB

    DrawDB

    Free, simple, and intuitive online database diagram editor

    DrawDB is an open source database diagramming tool for designing schemas visually and generating SQL from them. You create tables, columns, indexes, and foreign keys via drag-and-drop, and the app keeps relationships clear with clean, orthogonal connectors. It exports DDL for popular SQL dialects so you can move quickly from design to migration scripts. Projects can be saved, shared, and exported as images for documentation, making it useful for handoffs and reviews. The editor supports...
    Downloads: 13 This Week
    Last Update:
    See Project
  • 24
    PyMongo

    PyMongo

    PyMongo - the Official MongoDB Python driver

    The PyMongo distribution contains tools for interacting with MongoDB database from Python. The bson package is an implementation of the BSON format for Python. The pymongo package is a native Python driver for MongoDB. The gridfs package is a gridfs implementation on top of pymongo.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 25
    django-pgtrigger

    django-pgtrigger

    Write Postgres triggers for your Django models

    django-pgtrigger is a Django library for defining and managing PostgreSQL triggers directly in Python code. It allows developers to create database-level logic like automatic field updates, auditing, or validation without writing raw SQL. It’s ideal for teams that want stronger data integrity while keeping logic version-controlled.
    Downloads: 3 This Week
    Last Update:
    See Project
  • Previous
  • You're on page 1
  • 2
  • 3
  • 4
  • 5
  • Next