Search Results for "sql query builder"
Sort By:
Showing 243 open source projects for "sql query builder"
View related business solutions-
Custom VMs From 1 to 96 vCPUs With 99.95% UptimeLive migration and automatic failover keep workloads online through maintenance. One free e2-micro VM every month.
-
Veeam Data Platform v13.1Try Veeam Data Platform today. Experience the unified platform that's secure by design, portable by default, and proven to recover clean, fast, and anywhere.
-
1
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. -
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
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. -
4
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. -
$300 Free Credits to Build on Google CloudPut your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.
-
5
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. -
6
SQL Explorer
Easily share data across your company via SQL queries
...Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. SQL Explorer is inspired by any number of great query and reporting tools out there. -
7
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. -
8
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. -
9
Yearning SQL
A most popular sql audit platform for mysql
The MYSQL SQL audit tool used to unpack. Using the compiled binary files, only one database does not rely on any other plug-in to easily deploy. go+vue brings a smooth and beautiful user interface and powerful performance to Yearning. Yearning automatically reviews Mysql's syntax grammar norms based on Mysql grammar analysis and conducts functional audits based on the audit rules implemented by Yearning itself. -
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
10
SQL Studio
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB
SQL Studio is a database explorer supporting multiple databases like SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, and ClickHouse. -
11
Squel
SQL query string builder for Javascript
Squel is a JavaScript library for fluent and safe SQL query string building, usable both in Node.js environments and in the browser. Works in Node.js and in the browser. Supports the standard SQL queries: SELECT, UPDATE, INSERT, and DELETE. Supports non-standard commands for popular DB engines such as MySQL. Supports parameterized queries for safe value escaping. It can be customized to build any query or command of your choosing. -
12
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. -
13
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. -
14
GRDB.swift
A toolkit for SQLite databases
GRDB.swift is a comprehensive SQLite toolkit for Swift developers, providing type-safe database access through mapping to Swift structs and records. It offers query building, migrations, concurrency control, and Swift Codable integration—ideal for local or embedded data persistence in iOS, macOS, and cross-platform Swift applications. -
15
Kangaroo
Kangaroo is an AI-powered SQL client and admin tool for popular dbs
Kangaroo is an AI-powered SQL client designed to enhance database interaction by integrating large language model capabilities into query workflows. It allows users to write, analyze, and optimize SQL queries using natural language assistance, making database operations more accessible and efficient. The tool is intended for developers, analysts, and data professionals who want to simplify complex query generation and debugging processes. -
16
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 powerful filters and aggregations without complex configurations, making it easier to diagnose performance bottlenecks or uncover unusual events during testing and production. Stoolap supports dashboards, alert triggering, and exports so teams can embed visualizations in reports or monitor critical thresholds in real time. -
17
DBX
15MB, lightweight, cross-platform database client
...It works with relational, document, analytical, cache, search, and cloud-oriented databases, making it useful for developers who move across different data stacks. The project emphasizes a small footprint, avoiding the heavy Chromium bundling common in many desktop database tools. It includes a query editor with syntax highlighting, autocomplete, formatting, diagnostics, saved snippets, query history, and tab restoration. dbx also includes an AI SQL assistant that can generate, explain, optimize, and help fix SQL through compatible model providers. Its main value is combining broad database coverage, a modern query workflow, and lightweight deployment across desktop and self-hosted environments. -
18
sqlsmith
A random SQL query generator
SQLSmith is a fuzz testing tool for PostgreSQL that automatically generates random SQL queries to uncover bugs in the query planner and executor. It is widely used by PostgreSQL developers and database vendors to stress-test SQL features and engine behavior under edge-case conditions. SQLSmith helps improve database robustness by revealing unexpected failures. -
19
Squawk
Linter for Postgres migrations & SQL
Squawk is a static SQL linter for PostgreSQL designed to catch common mistakes and enforce query best practices. It analyzes raw SQL files and flags errors, anti-patterns, or style issues before queries are deployed. Squawk is ideal for teams that want to enforce SQL standards in CI pipelines. -
20
Noisia
Harmful workload generator for PostgreSQL
noisia is a PostgreSQL workload generator designed for testing and benchmarking query performance. It simulates real-world SQL traffic by replaying or generating workloads based on defined query profiles. noisia is useful for stress testing databases, tuning configurations, and validating changes in performance-sensitive environments. -
21
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. -
22
Beekeeper Studio
Cross-platform SQL Editor and Database Manager
Beekeeper Studio is an open source, cross-platform SQL editor and database management app that is both powerful and easy to use. It lets you query and manage your relational databases, with support for connecting to SQLite, MySQL, MariaDB, Postgres, SQL Server and Amazon Redshift databases. Unlike most other open source SQL editors and database managers, Beekeeper Studio isn’t cluttered with unnecessary features, but does come with the essentials that you need. ... -
23
Azure Data Studio
A data management tool that enables working with other SQL tools
...Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards. Use Azure Data Studio to query, design, and manage your databases and data warehouses wherever they are, on your local computer or in the cloud. Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). -
24
Prisma Client Go
Prisma Client Go is an auto-generated and fully type-safe database
...Model your data in the Prisma schema in a human-readable format. Prisma Client is a query builder that composes queries the way you think and is auto-generated from the Prisma schema with types tailored to your app. Prisma Migrate automatically generates SQL database migrations, that are fully customizable, enabling you to make changes to the database without generating migration files. -
25
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.
