Search Results for "sql queries"
Sort By:
Showing 34 open source projects for "sql queries"
View related business solutions-
Veeam Data Platform v13.1 - Get Your Free TrialTry Veeam Data Platform today. Experience the unified platform that's secure by design, portable by default, and proven to recover clean, fast, and anywhere.
-
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.
-
1
SQL Explorer
Easily share data across your company via SQL queries
SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! ... -
2
SQL Notebook
SQL Notebook — Casual data exploration in SQL
SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts. -
3
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. -
4
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. -
Earn up to 16% annual interest with Nexo.Generate interest, access liquidity without selling, and execute trades seamlessly. All in one platform. Geographic restrictions, eligibility, and terms apply.
-
5
pgTyped
pgTyped - Typesafe SQL in TypeScript
pgtyped brings type safety to SQL queries in TypeScript by parsing SQL files and generating typed query functions. It analyzes SQL against your PostgreSQL schema and outputs TypeScript code that ensures inputs and results are correctly typed. This allows teams to use raw SQL while retaining the safety and developer experience of TypeScript. -
6
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. -
7
Blazer
Business intelligence made simple
Blazer is a business-intelligence engine for Rails that lets teams write SQL in the browser, visualize the results, and share insights without leaving their app. It turns raw database queries into charts, tables, and dashboards, so non-engineers can explore data with minimal friction. Queries can accept parameters, enabling reusable reports for different time ranges, segments, or customers. Access controls and audit trails help teams manage who can run, edit, or view sensitive analyses. ... -
8
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. -
9
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. -
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
10
SPQR
Stateless Postgres Query Router
SPQR is a sharding proxy for PostgreSQL that enables horizontal scalability by distributing queries across multiple PostgreSQL instances. Designed for large-scale, multi-tenant architectures, SPQR routes, rewrites, and manages SQL queries to ensure they are executed efficiently across shards. It provides a PostgreSQL-compatible interface so applications can scale transparently without code changes. -
11
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. -
12
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. This includes SQL auto... -
13
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. -
14
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. -
15
Professional SQL Database Management Tool An application for managing MySQL, PostgreSQL, and SQLite databases with an intuitive GUI.
-
16
DB Explorer
The modern AI‑first database client for developers DBAs and analyst
DB Explorer is a free, cross-platform database query tool and schema explorer built for developers, DBAs, and data analysts. It provides a clean graphical interface for connecting to multiple database systems, writing and executing SQL, exploring schemas, monitoring database health, and generating SQL queries using AI — all from a single application. Supported Databases: PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLite, Amazon DynamoDB, and any JDBC-compatible database. -
17
Orbit
ORBIT : Operating Business Intelligence Tool
ORBIT : Operating Business Intelligence Tool Making Data Accessible Through Centralized Database Access ORBIT is a business intelligence tool designed to make data accessible to a broad audience within your company by centralizing access to databases. With this application, users can easily create reports, perform interactive analyses, and extract insights from raw data. The application simplifies data handling by providing easy-to-use features for non-technical users while maintaining... -
18
Records
Records is a simple, but powerful, library for making raw SQL queries
Queries support safe parameterization, SQL files, transactions, and bulk operations. Result collections can be converted into dictionaries or exported through Tablib to formats such as CSV, JSON, Excel, HTML, YAML, and Pandas DataFrames. A command-line utility allows SQL queries and exports to be performed outside Python code. The library focuses on keeping raw SQL workflows concise and readable. -
19
SQLStringSeeker
Ctrl+F for your MSSQL Database
This program connects to a users MSSQL Database, and searches it entirely for a search string. When finished, the results are populated in the log as preformatted queries that can be copy/pasted into SSMS for additional analysis. -
20
GraphQLmap
GraphQLmap is a scripting engine to interact with endpoints
...For a pentester, GraphQLmap speeds up discovery and exploitation workflows: you don’t just test known endpoints—you enumerate schema, fuzz fields, and chain queries. It offers a CLI, supports various HTTP methods, custom headers, proxies, and is designed to work with real-world GraphQL deployments. -
21
tabix
Tabix.io UI
Open source simple business intelligence application and sql editor tool for Clickhouse. Auto-completion of fields, dictionaries and functions. Tips on fields and functions in Russian and English. Reformatting queries / autoformat. Minimizes brackets and subqueries. Setting the autocompletion / enableLiveAutocompletion. Backlight brackets. The list of functions is loaded based on the capabilities of the server. -
22
sql-servant
Personal Query Servant
In your job, do you have queries that you are running regularly and sometimes you need to share those to non-technical people? Now you can do with your personal SQL Servant. Just configure and test it, if all is good distribute it. Those people doesn't need to have any fancy licensed SQL client. -
23
SQLTabs
Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift
SQLTabs is a cross-platform SQL client built using Electron and Vue.js that offers a modern and intuitive interface for managing SQL databases. It supports multiple database types and allows users to run queries in tabs, explore schemas, and view results in a clean, responsive UI. SQLTabs is designed for developers and analysts who need a simple yet powerful tool for database interaction. -
24
CStore FDW
Columnar storage extension for Postgres
cstore_fdw is a columnar store extension for PostgreSQL built by Citus Data using the Foreign Data Wrapper (FDW) interface. It stores data in a compressed, columnar format that significantly reduces disk I/O for analytical queries. Ideal for read-heavy workloads and time-series data, cstore_fdw enhances Postgres’ ability to serve as a lightweight data warehouse. -
25
SQLer
write APIs using direct SQL queries with no hassle
sqler is a lightweight API gateway that automatically exposes your SQL database as a RESTful API. It allows developers to run parameterized SQL queries safely over HTTP, turning databases into microservices without writing backend code. sqler is great for prototyping, dashboards, and internal tools with quick database integration.
