Showing 319 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
  • Automate contact and company data extraction Icon
    Automate contact and company data extraction

    Build lead generation pipelines that pull emails, phone numbers, and company details from directories, maps, social platforms. Full API access.

    Generate leads at scale without building or maintaining scrapers. Use 10,000+ ready-made tools that handle authentication, pagination, and anti-bot protection. Pull data from business directories, social profiles, and public sources, then export to your CRM or database via API. Schedule recurring extractions, enrich existing datasets, and integrate with your workflows.
    Explore Apify Store
  • 1
    Firebird

    Firebird

    Firebird server, client and tools

    Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, MacOS and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981. To enhance the Firebird functionality, IBSurgeon has sponsored the development and now released for public use the free open source "IBSurgeon Full Text...
    Downloads: 32 This Week
    Last Update:
    See Project
  • 2
    TinyDB

    TinyDB

    Document oriented database optimized for you

    TinyDB is a lightweight document oriented database optimized for your happiness :) It's written in pure Python and has no external dependencies. The target are small apps that would be blown away by a SQL-DB or an external database server. The current source code has 1800 lines of code (with about 40% documentation) and 1600 lines tests. Like MongoDB, you can store any document (represented as dict) in TinyDB. TinyDB is designed to be simple and fun to use by providing a simple and clean API. ...
    Downloads: 1 This Week
    Last Update:
    See Project
  • 3
    mycli

    mycli

    CLI for MySQL with auto-completion and syntax highlighting

    mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive.
    Downloads: 4 This Week
    Last Update:
    See Project
  • 4
    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: 0 This Week
    Last Update:
    See Project
  • Total Network Visibility for Network Engineers and IT Managers Icon
    Total Network Visibility for Network Engineers and IT Managers

    Network monitoring and troubleshooting is hard. TotalView makes it easy.

    This means every device on your network, and every interface on every device is automatically analyzed for performance, errors, QoS, and configuration.
    Learn More
  • 5
    Full Stack FastAPI and PostgreSQL

    Full Stack FastAPI and PostgreSQL

    Full stack, modern web application generator

    Generate a backend and frontend stack using Python, including interactive API documentation. Production ready Python web server using Uvicorn and Gunicorn. Very high performance, on par with NodeJS and Go (thanks to Starlette and Pydantic). Great editor support. Completion everywhere. Less time debugging. Designed to be easy to use and learn. Less time reading docs. Minimize code duplication. Multiple features from each parameter declaration. Get production-ready code. With automatic...
    Downloads: 2 This Week
    Last Update:
    See Project
  • 6
    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: 0 This Week
    Last Update:
    See Project
  • 7
    repmgr

    repmgr

    A lightweight replication manager for PostgreSQL (Postgres)

    repmgr is a management tool for PostgreSQL replication, providing monitoring, failover, and administrative capabilities for streaming replication setups. It simplifies the configuration of primary/standby clusters and automates failover processes for high availability. repmgr is widely used in production environments where database resilience and minimal downtime are critical.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 8
    StarRocks

    StarRocks

    StarRocks is a next-gen sub-second MPP database for full analytics

    ...From streaming data to change data capture, StarRocks meets the data ingestion demands of real-time analytics. Scale storage and computing power horizontally and support tens of thousands of concurrent users. All of your BI tools work with StarRocks through standard SQL. StarRocks provides superior performance. It is also a unified OLAP covering most data analytics scenarios.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 9
    MyBatis

    MyBatis

    MyBatis SQL mapper framework for Java

    MyBatis is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. MyBatis eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results. MyBatis can use simple XML or Annotations for configuration and map primitives, Map interfaces and Java POJOs (Plain Old Java Objects) to database records. Every MyBatis application centers around an instance of SqlSessionFactory. A SqlSessionFactory instance can be...
    Downloads: 3 This Week
    Last Update:
    See Project
  • Reach Your Audience with Rise Vision, the #1 Cloud Digital Signage Software Solution Icon
    Reach Your Audience with Rise Vision, the #1 Cloud Digital Signage Software Solution

    K-12 Schools, Higher Education, Businesses, Restaurants

    Rise Vision is the #1 digital signage company, offering easy-to-use cloud digital signage software compatible with any player across multiple screens. Forget about static displays. Save time and boost sales with 500+ customizable content templates for your screens. If you ever need help, get free training and exceptionally fast support.
    Learn More
  • 10
    Kysely

    Kysely

    A type-safe typescript SQL query builder

    Kysely (pronounce “Key-Seh-Lee”) is a type-safe and autocompletion-friendly typescript SQL query builder. Inspired by knex. Mainly developed for node.js but also runs on deno and in the browser. Kysely makes sure you only refer to tables and columns that are visible to the part of the query you're writing. The result type only has the selected columns with correct types and aliases. As an added bonus you get autocompletion for all that stuff. As shown in the gif above, through the pure magic...
    Downloads: 1 This Week
    Last Update:
    See Project
  • 11
    Mathesar

    Mathesar

    An intuitive spreadsheet-like interface

    Mathesar is an open-source platform designed to make databases accessible to non-technical users. It offers an intuitive spreadsheet-like interface on top of PostgreSQL, allowing users to create, edit, and analyze structured data without writing SQL. Built with user experience in mind, Mathesar empowers teams to collaborate on data-driven workflows while retaining the power of a real relational database.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 12
    EdgeDB

    EdgeDB

    A next-generation graph-relational database

    The world's favorite graph-relational database is back for an action-packed sequel. Tune in for a series of lightning talks breaking down what's new and what's next for EdgeDB. EdgeDB is an open-source database designed as a spiritual successor to SQL and the relational paradigm. It aims to solve some hard design problems that make existing databases unnecessarily onerous to use. Powered by the Postgres query engine under the hood, EdgeDB thinks about schema the same way you do: as objects...
    Downloads: 1 This Week
    Last Update:
    See Project
  • 13
    ERAlchemy

    ERAlchemy

    Entity Relation Diagrams generation tool

    ERAlchemy is a tool that generates Entity-Relationship (ER) diagrams from databases or SQLAlchemy models and vice versa. It’s useful for database documentation, reverse engineering, and understanding complex schemas. ERAlchemy can export diagrams in formats like Graphviz and Mermaid, making it easy to include in reports or markdown files.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 14
    AgensGraph

    AgensGraph

    AgensGraph, a transactional graph database based on PostgreSQL

    AgensGraph is a multi-model database that extends PostgreSQL with graph database capabilities, enabling users to work with both relational and graph data within a single system. It supports the Cypher query language alongside SQL, making it ideal for hybrid workloads.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 15
    Dungbeetle

    Dungbeetle

    A distributed job server

    Dungbeetle is a metadata and data lineage tracking tool developed by Zerodha to map and visualize how data flows across systems. It helps teams maintain data transparency by tracking dependencies between databases, tables, and reports, offering a centralized view of data pipelines. Dungbeetle is designed to enhance observability and trust in analytics ecosystems.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 16
    Phinx

    Phinx

    PHP database migrations for everyone

    Most database migration tools are framework-dependent, complicated, confusing to install/configure and a pain in the ass to write migrations for. In less than 5 minutes you can install Phinx, create and execute your first migration. Phinx supports migrations written in both PHP and SQL. Use the PHP syntax to make your migrations portable between different database vendors or hand-code advanced queries.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 17
    SQL DAL Maker

    SQL DAL Maker

    A generator of DTO, Model, and DAO classes to access relational DB

    SQL DAL Maker is a generator of DTO, Model, and DAO classes to access relational databases. Target programming languages: PHP, Java, C++, Python, and Go. To generate the class, you declare it in XML meta-program. At the stage of code generation, the target database must exist and be available for JDBC connection. Generated code is being synchronized with the current database schema using "live" JDBC metadata.
    Leader badge
    Downloads: 47 This Week
    Last Update:
    See Project
  • 18
    Postgres Meta

    Postgres Meta

    A RESTful API for managing your Postgres. Fetch tables, add roles

    ...It allows users to perform administrative tasks such as creating tables, views, functions, roles, and extensions programmatically through HTTP endpoints. Postgres Meta enables developers to integrate database management directly into dashboards, automation tools, or backend services without requiring SQL access or pgAdmin.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 19
    Prisma Client Go

    Prisma Client Go

    Prisma Client Go is an auto-generated and fully type-safe database

    ...Prisma Migrate automatically generates SQL database migrations, that are fully customizable, enabling you to make changes to the database without generating migration files.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 20
    manticoresearch

    manticoresearch

    Easy to use open source fast database for search

    Manticore Search is an easy to use open source fast database for search. Modern MPP architecture and smart query parallelization capabilities allow to fully utilize all your CPU cores to lower response time as much as possible, when needed. Powerful and fast full-text searching which works fine for small and big datasets. Columnar storage support via the Manticore Columnar Library for bigger datasets (much bigger than can fit in RAM). SQL-first: Manticore's native syntax is SQL. It speaks...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 21
    Upscheme

    Upscheme

    Database migrations and schema updates made easy

    ...With support for major relational database systems via Doctrine DBAL, Upscheme enables cross-platform migrations with minimal code, reducing friction when evolving your application’s data model. The project includes tools to generate migration files, handle dependencies between tasks, and execute changes reliably across environments without requiring low-level SQL scripting. By focusing on upgrades and avoiding potentially unsafe downgrades, it prioritizes safety and predictability for real-world application upgrades.
    Downloads: 4 This Week
    Last Update:
    See Project
  • 22

    oracle-architect-tools

    oracle pl/sql based tools for design development and maintenance

    A suite of open source utilities written in Oracle PL/SQL for schema instrumentation, auditing, schema administration scripting, ddl mapping and migration code generation, dml package generation, and xml service package generation based on metadata tables
    Downloads: 0 This Week
    Last Update:
    See Project
  • 23
    HammerDB

    HammerDB

    HammerDB Database Load Testing and Benchmarking Tool

    HammerDB is a leading benchmarking and load testing tool for relational databases like PostgreSQL, Oracle, SQL Server, and MySQL. It implements industry-standard workloads such as TPC-C and TPC-H to simulate real-world transactional and analytical database performance. HammerDB is widely used by DBAs and performance engineers to evaluate hardware, configurations, and scaling.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 24
    Java 2D & 3D visual entity relationship design & modeling (ERD,SQL) for Oracle,MSSQL,Postgres,MySQL,...,Database change&dictionary management, Swing Data Binding, Apache FOP Renderer for dot matrix printers,Sparx Enterprise Architect Reports + more
    Downloads: 1 This Week
    Last Update:
    See Project
  • 25
    SurrealDB

    SurrealDB

    A scalable, distributed, collaborative, document-graph database

    With an SQL-style query language, real-time queries with highly-efficient related data retrieval, advanced security permissions for multi-tenant access, and support for performant analytical workloads, SurrealDB is the next generation serverless database. SurrealDB is the ultimate cloud database for tomorrow's applications. SurrealDB is an innovative NewSQL cloud database, suitable for serverless applications, jamstack applications, single-page applications, and traditional applications. It...
    Downloads: 2 This Week
    Last Update:
    See Project