Search Results for "visual query builder for postgresql"
Sort By:
Showing 33 open source projects for "visual query builder for postgresql"
View related business solutions-
Next-Gen Encryption for Post-Quantum Security | CLEAR by Quantum KnightCLEAR by Quantum Knight is a FIPS-140-3 validated encryption SDK engineered for enterprises requiring top-tier security. Offering robust post-quantum cryptography, CLEAR secures files, streaming media, databases, and networks with ease across over 30 modern platforms. Its compact design, smaller than a single smartphone image, ensures maximum efficiency and low energy consumption.
-
Award-Winning Medical Office Software Designed for Your SpecialtyRXNT is an ambulatory healthcare technology pioneer that empowers medical practices and healthcare organizations to succeed and scale through innovative, data-backed, AI-powered software.
-
1
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. -
2
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. -
3
Kysely SQL
A type-safe TypeScript SQL query builder
Kysely is a type-safe TypeScript SQL query builder that provides an intuitive and autocompletion-friendly API. It allows developers to construct complex SQL queries with full type safety, reducing runtime errors and improving code maintainability. Kysely supports various SQL dialects and is compatible with Node.js, Deno, and browser environments. -
4
SqlKata QueryBuilder
SQL query builder, written in c#, helps you build complex queries
SqlKata is a powerful and elegant SQL query builder for .NET that provides a fluent, expressive syntax to construct complex SQL queries programmatically. It supports multiple database engines and can compile queries to raw SQL with parameters, making it easy to integrate with Dapper or ADO.NET. SqlKata emphasizes flexibility and readability, enabling developers to write maintainable and reusable query logic. -
Data management solutions for confident marketingVerify, deduplicate, manipulate, and assign records automatically to keep your CRM data accurate, complete, and ready for business.
-
5
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. -
6
atk4/data
Data Access PHP Framework for SQL & high-latency databases
ATK Data is a data persistence and modeling framework for PHP, developed as part of the Agile Toolkit. It provides a high-level abstraction for working with databases, making it easier to define and manipulate data models with minimal boilerplate code. It supports various SQL and NoSQL databases and integrates seamlessly with Agile UI and other PHP frameworks. -
7
SQLTools
Database management for VSCode
VSCode-SQLTools is a Visual Studio Code extension that enhances database management and development. It provides a rich set of features for connecting to databases, executing queries, and managing data directly within the code editor. -
8
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... -
9
Stoolap
A Modern Embedded SQL Database written in Rust
Stoolap is a lightweight, self-hosted analysis and visualization tool designed to help developers and operations teams explore log data, metrics, and debugging information from distributed systems or local applications. Instead of relying on heavy commercial observability platforms, stoolap provides a fast, focused interface where users can filter, query, and visualize time-series data, logs, traces, and error metrics in a cohesive environment. Its intuitive query builder lets users craft... -
Iris Powered By Generali - Iris puts your customer in control of their identity.Iris Identity Protection API sends identity monitoring and alerts data into your existing digital environment – an ideal solution for businesses that are looking to offer their customers identity protection services without having to build a new product or app from scratch.
-
10
pgBadger
A fast PostgreSQL Log Analyzer
pgBadger is a fast and powerful log analyzer for PostgreSQL, written in Perl. It parses PostgreSQL logs and generates detailed, visually appealing HTML reports, helping DBAs and developers understand query performance, connection issues, and system bottlenecks. With support for incremental analysis, gzip-compressed logs, and parallel processing, pgBadger is ideal for monitoring and optimizing PostgreSQL database activity in production environments. -
11
Piccolo
A fast, user friendly ORM and query builder which supports asyncio
Piccolo is a modern, fast, and type-safe ORM for Python, designed with developer ergonomics in mind. It provides a clean syntax for defining schemas and building queries while supporting both sync and async execution. With built-in admin tools and rich introspection, Piccolo is suitable for web apps, APIs, and small-to-medium scale backends that prioritize clarity and speed. -
12
Doctrine JSON Functions
Doctrine DQL functions for SQL JSON data type
DoctrineJsonFunctions is a library that adds native support for JSON-related SQL functions to Doctrine ORM. It extends Doctrine’s DQL capabilities to handle PostgreSQL, MySQL, and SQLite JSON functions, enabling developers to write expressive queries involving JSON fields directly in DQL. This is especially useful for applications that store semi-structured data in relational databases. -
13
Toolpad Core
Full stack components and low-code builder for dashboards and internal
Toolpad is a self‑hosted, open‑source, low‑code admin/dashboard builder and a collection of full-stack React components tailored for building internal tools and dashboards. Created by the team behind Material‑UI (MUI), it enables rapid development by combining drag‑and‑drop UI construction with tight backend integration. Toolpad Core provides the component library for Next.js/Vite projects, while the deprecated Toolpad Studio offered a visual builder interface. Toolpad Core is a set of high... -
14
Prisma Client Go
Prisma Client Go is an auto-generated and fully type-safe database
Get started in minutes with a new or existing database. Use full type safety and automated workflows to ship schema changes and write queries with less work. Prisma Client Go is an auto-generated query builder that enables type-safe database access and reduces boilerplate. You can use it as an alternative to traditional ORMs such as gorm, xorm, sqlboiler and most database-specific tools. It is part of the Prisma ecosystem. Prisma provides database tools for data access, declarative data modeling, schema migrations and visual data management. ... -
15
Prisma
Next-generation ORM for Node.js and TypeScript
Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. Central to Prisma is the schema, a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that. Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. ... -
16
DbGate
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application. DbGate is a cross-platform database manager. It's designed to be simple to use and effective when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualization or batch export and import. -
17
Chartbrew
Open-source web platform used to create live reporting dashboards
Chartbrew is an open-source web application that can connect directly to databases and APIs and use the data to create beautiful charts. It features a chart builder, editable dashboards, embeddable charts, query & requests editor, and team capabilities. It is recommended you head over to the more detailed documentation to find out how to set up Chartbrew. The CLI tool creates a chartbrew/.env file which you can configure at any time if you want to change the database, API & client host, etc.... -
18
REL
Modern ORM for Golang
REL is a modern and lightweight ORM for Go that emphasizes testability, flexibility, and composability. It supports a repository pattern and expressive query building with support for advanced SQL features. REL aims to make it easier to write maintainable, testable, and readable database logic in idiomatic Go. -
19
tabularis
An open-source desktop client for modern databases.
Tabularis is a free, open-source desktop database client for PostgreSQL, MySQL/MariaDB, and SQLite. Built with Rust and Tauri v2, it is fast, lightweight, and cross-platform (Windows, macOS, Linux). Features: SQL Notebooks with inline charts and cross-cell variables. AI-powered SQL assistant (OpenAI, Claude, Ollama, and more). Built-in MCP server for AI agent integration. Visual Query Builder with drag-and-drop JOINs. -
20
NodeTool
Visual AI Workflow Builder
NodeTool is an open‑source, visual AI workflow builder that lets you connect nodes for text, images, audio, video, data, and automation—then run them locally or on the cloud. Build multi‑step agents, RAG systems, and creative media pipelines without coding, inspect execution in real time, and deploy anywhere: home server, private VPC, RunPod, or Cloud Run. With a local‑first design, NodeTool keeps models and data under your control while still supporting providers like OpenAI, Anthropic,... -
21
Openblocks
The Open Source Retool Alternative
It's cumbersome to create a single app. You had to design user interfaces, write code in multiple languages and frameworks, and understand how all of that code works together. Low-code/No-code platforms are fast to get started with but quickly become unmaintainable and inflexible. This creates more problems than it solves. Retool-like solutions are great for their simplicity and flexibility, but they can also be limited in different ways compared to frameworks like React/Vue. An all-in-one... -
22
Aestel
Applications for data management
"Information is data in action", and, consequently, having good quality data is essential. The AESTEL package contains two highly configurable applications for data management: A data loader and a reporting application, i.e. DataLoader and AEREA, respectively. The data loader application applies user-defined instructions to validate, process and load data. The reporting application provides a query builder and spreadsheet template designer. Both applications work with any relational data... -
23
SQLeo Visual Query Builder
Helping users to quickly understand SQL queries
...(but MySQL jdbc and CsvJdbc are the only driver included in the package) Can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed, Oracle SQL developer, Toad, DbVisualizer, MySQL Workbench, DBeaver, Aqua Data Studio ... -
24
bookshelf.js
A simple Node.js ORM for PostgreSQL, MySQL and SQLite3
Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. It features both Promise-based and traditional callback interfaces, transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. Bookshelf aims to provide a simple library for common tasks when querying databases in JavaScript, and forming relations between these objects, taking a lot of ideas from the Data Mapper Pattern.... -
25
Orator
The Orator ORM provides a simple yet beautiful ActiveRecord implement.
The Orator ORM provides a simple yet beautiful ActiveRecord implementation. The Orator ORM is based on conventions to avoid the hassle of defining every single aspect of your models. It is inspired by the database part of the Laravel framework, but largely modified to be more pythonic. All you need to get you started is the configuration describing your database connections and passing it to a DatabaseManager instance. If you have multiple databases configured you can specify which one is...
