Showing 221 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
  • Inventors: Validate Your Idea, Protect It and Gain Market Advantages Icon
    Inventors: Validate Your Idea, Protect It and Gain Market Advantages

    SenseIP is ideal for individual inventors, startups, and businesses

    senseIP is an AI innovation platform for inventors, automating any aspect of IP from the moment you have an idea. You can have it researched for uniqueness and protected; quickly and effortlessly, without expensive attorneys. Built for business success while securing your competitive edge.
    Learn More
  • 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: 35 This Week
    Last Update:
    See Project
  • 2
    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: 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
  • The Original Buy Center Software. Icon
    The Original Buy Center Software.

    Never Go To The Auction Again.

    VAN sources private-party vehicles from over 20 platforms and provides all necessary tools to communicate with sellers and manage opportunities. Franchise and Independent dealers can boost their buy center strategies with our advanced tools and an experienced Acquisition Coaching™ team dedicated to your success.
    Learn More
  • 5
    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: 3 This Week
    Last Update:
    See Project
  • 6
    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
  • 7
    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
  • 8
    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: 2 This Week
    Last Update:
    See Project
  • 9
    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
  • Leverage AI to Automate Medical Coding Icon
    Leverage AI to Automate Medical Coding

    Medical Coding Solution

    As a healthcare provider, you should be paid promptly for the services you provide to patients. Slow, inefficient, and error-prone manual coding keeps you from the financial peace you deserve. XpertDox’s autonomous coding solution accelerates the revenue cycle so you can focus on providing great healthcare.
    Learn More
  • 10
    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: 5 This Week
    Last Update:
    See Project
  • 11
    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
  • 12
    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
  • 13
    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: 3 This Week
    Last Update:
    See Project
  • 14
    tccutil.py

    tccutil.py

    Command line tool to modify OS X's accessibility database (TCC.db)

    Apple has a utility in /usr/bin named tccutil, but it only supports one command, which is to reset the entire database. It has been like this for many versions of macOS. I wanted a command-line utility that would be able to add, remove, list, and take other actions. This tool needs SIP disabled in order to function. The risk of doing so is up to you. tccutil.py can be installed without any additional software. Depending how you have your $PATH variable setup, you can simply type tccutil...
    Downloads: 2 This Week
    Last Update:
    See Project
  • 15
    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: 2 This Week
    Last Update:
    See Project
  • 16
    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: 3 This Week
    Last Update:
    See Project
  • 17
    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: 5 This Week
    Last Update:
    See Project
  • 18
    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: 37 This Week
    Last Update:
    See Project
  • 19
    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
  • 20
    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
  • 21
    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
  • 22
    Dokploy

    Dokploy

    Open Source Alternative to Vercel, Netlify and Heroku

    Streamline your operations with our all-in-one platform, perfect for managing projects, data, and system health with simplicity and efficiency. Simplify your project and data management, ensure robust monitoring, and secure your backups—all without the fuss over minute details. Elevate your infrastructure with tools that offer precise control, detailed monitoring, and enhanced security, ensuring seamless management and robust performance. Streamline your deployments with our PaaS....
    Downloads: 0 This Week
    Last Update:
    See Project
  • 23
    Firebird

    Firebird

    A powerful, cross platform, SQL database system

    Firebird RDBMS offers ANSI SQL features & runs on Linux, Windows & several Unix platforms. Features excellent concurrency & performance & powerful stored procedure & trigger language. More information and downloads at https://firebirdsql.org/, issue tracker is https://github.com/FirebirdSQL/firebird/issues
    Leader badge
    Downloads: 4,253 This Week
    Last Update:
    See Project
  • 24

    SQLObject

    SQLObject is a Python ORM.

    SQLObject is an object-relational mapper for Python. It supports MySQL, PostgreSQL, SQLite, Firebird, MaxDB/SapDB, MS SQL and Sybase. It supports Python versions back to 2.7.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 25

    pyDaSSQLiteMan

    An easy way to manage SQLite databases and query CSV files

    Welcome to the project page for pyDaSSQLiteMan (Python Data and SQLite Manager). This application is a Python Tkinter application designed to enable easy SQLite database file manipulation, and an easy method to run SQL styled queries on CSV files. If you're not downloading the pre-compiled executable you will need Python to run this app. You can download it from http://www.python.org/ .
    Downloads: 5 This Week
    Last Update:
    See Project