Showing 2020 open source projects for "gui sql database"

View related business solutions
  • Silverware is an enterprise-grade hospitality platform built for hotels, resorts, and complex multi-venue operations. Icon
    Silverware is an enterprise-grade hospitality platform built for hotels, resorts, and complex multi-venue operations.

    Silverware powers high-end hospitality environments

    Silverware is built for hotel, resort, and multi-venue hospitality operators who need enterprise-grade control, deep integrations, and always-on reliability to run complex operations at scale.
    Learn More
  • Job Evaluation and Talent Management Software Icon
    Job Evaluation and Talent Management Software

    For human resources departments in search of a tool to manage time, expenses, leave, documents, recruitment, and onboarding

    Encompassing Visions (ENCV), industry-leading job evaluation and pay equity software, is the best choice for organizations requiring transparent, comprehensive, and objective Job Evaluation software designed to help them ensure equal pay for work of equal value.
    Learn More
  • 1
    pg_cron

    pg_cron

    Run periodic jobs in PostgreSQL

    pg_cron is a PostgreSQL extension that allows SQL jobs to be scheduled using cron syntax. It runs inside the database server and lets users automate routine tasks like VACUUM, backups, and custom SQL scripts. Jobs are managed via SQL commands and can run on the same schedule format as standard UNIX cron, making it powerful and easy to use for database administrators and developers alike.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 2
    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
  • 3
    Bob

    Bob

    SQL query builder and ORM/Factory generator for Go

    Bob is a SQL query builder for Go that emphasizes composability, type safety, and maintainability. It allows developers to construct dynamic queries in a programmatic and reusable way, supporting both simple and complex SQL logic. Bob helps avoid raw string concatenation, making Go-based database interactions more robust and testable.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 4
    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: 0 This Week
    Last Update:
    See Project
  • Hightouch is a data and AI platform for marketing and personalization. Icon
    Hightouch is a data and AI platform for marketing and personalization.

    Marketing needs data and AI. Give them Hightouch.

    Find insights, run real-time campaigns, and build AI agents with all your data.
    Learn More
  • 5
    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. ...
    Downloads: 25 This Week
    Last Update:
    See Project
  • 6
    DbTpl

    DbTpl

    Command line tool to generate idiomatic Go code for SQL databases

    dbtpl is a Go-based tool that brings templated SQL into your codebase in a clean and structured way. It allows developers to define raw SQL queries in .tpl.sql files and compile them into Go code with strong typing and minimal overhead. By combining SQL’s power with Go’s safety and performance, dbtpl is ideal for teams that want full SQL control without sacrificing maintainability.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 7
    SQLPad

    SQLPad

    Web-based SQL editor run in your own private cloud

    A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, Snowflake, Google BigQuery, SQLite, TiDB, and many more via ODBC. The docker image runs on port 3000 and uses /var/lib/sqlpad for the embedded database directory. latest tag is continuously built from latest commit in repo.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 8
    ClickHouse

    ClickHouse

    A fast open-source OLAP database management system

    ClickHouse® is a fast, open-source column-oriented database management system that can generate analytical data reports through SQL queries in real time. According to several independent benchmarks, it far exceeds other comparable column-oriented database management systems, working even up to 1000 times faster. It is able to process hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second.
    Downloads: 23 This Week
    Last Update:
    See Project
  • 9
    Chat2DB

    Chat2DB

    AI-driven database tool and SQL client

    Save time by working with data. Connect to all your data sources, and instantly generate optimal SQL for fast lightning information. If you don't know SQL well, you can get instant information without writing SQL. Generate high-performance SQL for your complicated queries using natural language, as well as correcting errors and getting AI suggestions to optimize the performance of SQL queries. Developers can write complex SQL queries quickly and accurately with the help of the AI SQL editor,...
    Downloads: 2 This Week
    Last Update:
    See Project
  • Deliver trusted data with dbt Icon
    Deliver trusted data with dbt

    dbt Labs empowers data teams to build reliable, governed data pipelines—accelerating analytics and AI initiatives with speed and confidence.

    Data teams use dbt to codify business logic and make it accessible to the entire organization—for use in reporting, ML modeling, and operational workflows.
    Learn More
  • 10
    node-mssql

    node-mssql

    Microsoft SQL Server client for Node.js

    node-mssql is a Microsoft SQL Server client for Node.js, providing a robust and feature-rich interface for connecting to and interacting with SQL Server databases.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 11
    DuckDB

    DuckDB

    DuckDB is an in-process SQL OLAP Database Management System

    DuckDB is a high-performance analytical database system. It is designed to be fast, reliable and easy to use. DuckDB provides a rich SQL dialect, with support far beyond basic SQL. DuckDB supports arbitrary and nested correlated subqueries, window functions, collations, complex types (arrays, structs), and more. For more information on the goals of DuckDB, please refer to the Why DuckDB page on our website.
    Downloads: 6 This Week
    Last Update:
    See Project
  • 12
    HoneySQL

    HoneySQL

    Turn Clojure data structures into SQL

    HoneySQL is a Clojure library that transforms data-structure-based query descriptions into SQL strings (with parameter separation). It focuses purely on generation—leaving execution to libraries like next.jdbc. It supports complex constructs (JOINs, subqueries, CTEs), and allows dynamic query-building with safety and readability.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 13
    Grafana

    Grafana

    Leading open-source visualization and observability platform

    Grafana OSS is the leading open-source platform for visualization and observability. It enables teams to query, visualize, alert on, and explore telemetry data from multiple sources in a single interface. With support for 100+ data source plugins—including Prometheus, Loki, Elasticsearch, InfluxDB, SQL/NoSQL databases, and OpenTelemetry—Grafana helps teams correlate metrics, logs, and traces across applications and infrastructure. Users can build interactive dashboards with rich...
    Downloads: 35 This Week
    Last Update:
    See Project
  • 14
    PHP-CRUD-API

    PHP-CRUD-API

    Single file PHP script that adds a REST API to a SQL database

    Single file PHP script that adds a REST API to a MySQL/MariaDB, PostgreSQL, SQL Server or SQLite database. Howto: Upload "api.php" to your webserver, configure it to connect to your database, have an instant full-featured REST API. This is the TreeQL reference implementation in PHP. This is a single file application! Upload "api.php" somewhere and enjoy! For local development you may run PHP's built-in web server.
    Downloads: 8 This Week
    Last Update:
    See Project
  • 15
    directus

    directus

    Directus wraps any SQL database with a real-time GraphQL+REST API

    ...Directus is the world's leading Open Data Platform, with millions of downloads, thousands of active developers, and we're just getting warmed up. Start with a new or existing database, using any SQL vendor, Directus takes care of the rest. The Directus API layers on top of your database, providing both REST and GraphQL APIs for your data.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 16
    Fluent

    Fluent

    Vapor ORM (queries, models, and relations) for NoSQL and SQL databases

    ...If you have an existing project that you want to add Fluent to, you will need to add two dependencies to your package. PostgreSQL is an open source, standards compliant SQL database. It is easily configurable on most cloud hosting providers. This is Fluent's recommended database driver.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 17
    PowerUpSQL

    PowerUpSQL

    A PowerShell toolkit for attacking SQL Server

    PowerUpSQL is a PowerShell toolkit focused on auditing, discovering, and post-exploitation activities for Microsoft SQL Server environments. It bundles a wide range of functions that help enumerate SQL Server instances, configuration settings, and potentially risky features so operators and testers can quickly understand an instance's security posture. The project is aimed at internal penetration testers and red-teamers but is also useful for database administrators and defenders who want to inventory SQL Server attack surface and hunt for misconfigurations. ...
    Downloads: 1 This Week
    Last Update:
    See Project
  • 18
    Knex

    Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, etc.

    Knex.js is a flexible and portable SQL query builder for JavaScript. It supports multiple database systems, including PostgreSQL, MySQL, SQLite3, and more. Knex.js offers a powerful and intuitive API for building and executing SQL queries, making it a popular choice for Node.js applications requiring database interactions.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 19
    HHDB SQL Admin

    HHDB SQL Admin

    HHDB SQL Admin is a graphical PostgreSQL client written in Java.

    1. Developed by pure java 2. Customrized for PostgreSQL 3. Support multi-language 4. Use pg JDBC driver for connection 5. Use swing components for GUI 6. Test with Jdk1.7 and 1.8 on windows and CentOS 6,7
    Downloads: 4 This Week
    Last Update:
    See Project
  • 20
    Digoal Blog

    Digoal Blog

    Opensource, Database, AI, Business

    Digoal Blog is a comprehensive collection of articles, tutorials, and resources focused on open-source databases, particularly PostgreSQL. Maintained by Digoal Zhou, the blog covers a wide range of topics including database optimization, architecture, and best practices, serving as a valuable resource for database administrators and developers.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 21
    Temporal Tables

    Temporal Tables

    Postgresql temporal_tables extension in PL/pgSQL

    temporal_tables is a PostgreSQL extension that adds temporal support to tables by automatically tracking row history. It enables versioned records, letting users query data as it existed at any point in time. This is ideal for audit logging, data versioning, and time-travel queries without needing manual triggers or archive tables.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 22
    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: 4 This Week
    Last Update:
    See Project
  • 23
    go-mysql-server

    go-mysql-server

    A MySQL-compatible relational database with a storage agnostic query

    go-mysql-server is a data-source agnostic SQL engine and server which runs queries on data sources you provide, using the MySQL dialect and wire protocol. A simple in-memory database implementation is included, and you can query any data source you want by implementing your own backend. Dolt, a SQL database with Git-style versioning, is the main production database implementation of this package.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 24
    Supabase Wrappers

    Supabase Wrappers

    Postgres Foreign Data Wrapper development framework in Rust

    Supabase Wrappers is a collection of PostgreSQL extensions (written in Rust) that allow Postgres to interact with external systems like APIs, files, and other databases. It uses Foreign Data Wrappers (FDWs) to treat external resources as if they were native SQL tables, enabling seamless integration with external services directly from SQL queries.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 25
    SeaQuery

    SeaQuery

    A dynamic SQL query builder for MySQL, Postgres and SQLite

    SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, Postgres and SQLite behind a common interface that aligns their behavior where appropriate.
    Downloads: 0 This Week
    Last Update:
    See Project
MongoDB Logo MongoDB