Search Results for "sql tools python" - Page 2
Sort By:
Showing 378 open source projects for "sql tools python"
View related business solutions-
Our Free Plans just got better! | Auth0You 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.
-
Grafana: The open and composable observability platformGrafana is the open source analytics & monitoring solution for every database.
-
1
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. ... -
2
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. -
3
PLpgSQL Check
plpgsql_check is a linter tool (does source code static analyze)
plpgsql_check is a PostgreSQL extension for static analysis and runtime checking of PL/pgSQL functions. It helps developers catch bugs early by analyzing code structure, variable usage, and SQL correctness before execution. The extension is ideal for improving code quality in large Postgres-based applications. -
4
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... -
AI-First Supply Chain ManagementLogility is a market-leading provider of AI-first supply chain management solutions engineered to help organizations build sustainable digital supply chains that improve people’s lives and the world we live in. The company’s approach is designed to reimagine supply chain planning by shifting away from traditional “what happened” processes to an AI-driven strategy that combines the power of humans and machines to predict and be ready for what’s coming. Logility’s fully integrated, end-to-end platform helps clients know faster, turn uncertainty into opportunity, and transform the supply chain from a cost center to an engine for growth.
-
5
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. -
6
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. -
7
INS
Inspiration database for Internet practitioners with no ads
INS is described as a kind of “inspiration database for internet workers” — a repository that collects and curates interesting websites, tools, links, or resources that might inspire developers, designers, or any knowledge workers. It aims to operate without ads, focusing purely on the content and resource quality, and leverages automation (e.g. GitHub Actions) to check link validity or site load speed, ensuring that listed resources remain accessible over time. For people in tech who... -
8
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... -
9
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. -
Pest Control Management SoftwareBuilt for the pest control industry, but also works great for Mosquito Control, Bin Cleaning, Window Washing, Solar Panel Cleaning, and other Home Service Businesses in need of an easy-to-use software that helps you simplify routing, scheduling, communications, payment processing, truck tracking, time tracking, and reporting.
-
10
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. -
11
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. -
12
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... -
13
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... -
14
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... -
15
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. -
16
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... -
17
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. -
18
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. -
19
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. -
20
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. -
21
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
-
22
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. -
23
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 -
24
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... -
25
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.
