Search Results for "visual query builder for postgresql"
Sort By:
Showing 34 open source projects for "visual query builder for postgresql"
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.
-
The TMS Designed for Freight BrokersTai Software is a fully integrated Transportation Management System (TMS) built to meet the real needs of freight brokers. It efficiently manages Full Truckload (FTL), Less Than Truckload (LTL), and more, helping optimize operations, enhance carrier selection, win more business, and improve profitability. Tai connects with leading LTL carriers, load boards, tracking tools, and other platforms to centralize workflows and eliminate inefficiencies.
-
1
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. -
2
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. -
3
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. -
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. -
Cloud-hosted construction project information management for improved communication, and increased efficiency.Newforma empowers over 4M professionals and 1,500 AECO firms worldwide by revolutionizing Project Information Management. We transform vast amounts of project data into a meticulously organized, easily accessible, and fully searchable resource—all from a single, centralized platform. From pre-construction to years after completion, Newforma ensures you have the critical information you need at every stage of your projects.
-
5
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. -
6
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. -
7
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. -
8
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. -
9
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. -
Cycloid: Hybrid Cloud DevOps collaboration platformEnable your developers to do their best work and increase time-to-market speed with a leading DevOps and Hybrid Cloud platform.
-
10
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. -
11
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... -
12
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. -
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
Joget
AI Powered Open Source Platform to Easily Build Enterprise Web Apps
Joget offers an open-source, AI-powered platform that converges no-code/low-code development with AI to rapidly build and customize enterprise applications at scale. By combining AI with visual app builders—not raw code—Joget makes app generation faster, safer, and more accessible for everyone. With Generative AI and Agentic AI capabilities, Joget Intelligence enables organizations to automate and enhance processes while maintaining oversight and compliance. Unlike typical AI code... -
19
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... -
20
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... -
21
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 ... -
22
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.... -
23
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... -
24
go-kallax
Kallax is a PostgreSQL typesafe ORM for the Go language
go-kallax is a type-safe ORM for Go, designed to work seamlessly with PostgreSQL. It generates Go code from your database schema using model definitions, allowing for clean and performant data access without raw SQL. The library is built with Go idioms in mind and focuses on compile-time safety and ease of use. -
25
schemats
Generate typescript interface definitions from SQL database schema
Schemats is a TypeScript code generator that creates type definitions from existing PostgreSQL schemas. It helps developers working with raw SQL or query builders to maintain strong typing and avoid runtime errors. By analyzing database schemas, Schemats bridges the gap between relational databases and TypeScript-based applications.
