Search Results for "sql query"
Sort By:
Showing 37 open source projects for "sql query"
View related business solutions-
Eurekos LMS - Build a Smarter CustomerEurekos is a purpose-built LMS that engages customers throughout the entire learning journey from pre-sales, to onboarding, and everything after.
-
Junie, the AI coding agent by JetBrainsJunie is an AI-powered coding agent developed by JetBrains designed to enhance developer productivity by integrating directly into popular IDEs such as IntelliJ IDEA, PyCharm, and Android Studio. It supports developers by assisting with code completion, testing, and inspections, ensuring code quality and reducing debugging time.
-
1
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. -
2
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. -
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
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. -
B2i offers full-service IR websites, widgets and pluginsB2i Technologies provides the most robust and versatile tools to manage your Corporate website, Investor Relations website and email communications. Our Investor Relations Software solutions work through automation and implements into existing systems with ease in only a few steps. Our solutions not only help you stay compliant but save valuable time while reporting and delivering critical financial data and press release activities to investors. B2i's Investor Relations Solution provides highly reliable and customizable data for corporate websites including press releases, stock data, charting, and SEC filings within SOX compliance standards. Our investor relations software displays real-time data on your website without requiring additional work on your behalf. Once you have completed your filings and press releases they are automatically loaded onto your website and formatted for easy access.
-
5
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). -
6
SQLiteStudio
A free, open source, multi-platform SQLite database manager
...You can execute SQL statements that refer to multiple databases within a single query, thanks to a transparent database attaching mechanism built into the SQL Editor of SQLiteStudio. You can implement your own SQL functions (scalar & aggregate) using JavaScript, Python, or Tcl. There is a repository of ready-to-use scripts on the wiki page. -
7
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. -
8
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. ... -
9
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. -
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.
-
10
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. -
11
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. -
12
Redash
Connect to any data source, easily visualize and share your data
Redash is an essential tool to help you make sense of your data. It allows everyone, regardless of level of technical know-how to harness the power of data. SQL users connect, query, visualize and share data easily and efficiently, allowing everyone in their organization to use the data. Redash combines the power and comfort of an SQL client with the collaborative benefits of a cloud-based service. It lets you create big, beautiful and easy to digest visualizations on dashboards for better decision-making. ... -
13
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. -
14
Apache AGE
Graph database optimized for fast analysis
Apache AGE (A Graph Extension) is a PostgreSQL extension that adds support for graph database functionality using the openCypher query language. AGE allows users to store and query graph-structured data alongside traditional relational data in a single database. Built for performance and scalability, it brings the power of graph queries to the robustness of PostgreSQL, making it suitable for use cases like social networks, recommendation systems, and fraud detection. -
15
Bdash
Simple SQL Client for lightweight data analysis
Simple SQL Client for lightweight data analysis. You can share the result with gist. Supports MySQL, PostgreSQL (Amazon Redshift), SQLite3, Google BigQuery, Treasure Data, Amazon Athena. You can download and install from Web Site or Releases. -
16
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. -
17
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. -
18
DB Explorer
The modern AI‑first database client for developers DBAs and analyst
DB Explorer is a powerful, cross-platform Java-based database query tool and explorer designed for developers, DBAs, and data analysts. It provides an intuitive GUI for connecting to multiple databases including PostgreSQL, MySQL, SQL Server, Oracle, SQLite and Dynamo DB along with support of connection any of database via Generic JDBC driver. Key features include real-time SQL execution with syntax highlighting, interactive schema browsing, result pagination with lazy loading, query export capabilities, and memory management controls including a garbage collection button. ... -
19
Delphi Direct ORACLE Access Components
Rich library of Delphi components for native connectivity to Oracle
Delphi OCI Components (DOCI) is a rich and high-performance library of components for native connectivity to Oracle from Delphi. DOCI applications connect to Oracle directly through Oracle Call Interface (OCI) which makes DOCI applications so fast. DOCI components library aims to assist programmers in developing of fast and native Oracle database applications. It is an efficient native alternative to the Borland Database Engine (BDE) and Delphi dbExpress driver. -
20
GraphQLmap
GraphQLmap is a scripting engine to interact with endpoints
GraphQLmap is a Python-based scripting engine designed to interact with GraphQL endpoints for penetration testing purposes. It can connect to a target GraphQL endpoint, dump the schema (if introspection is enabled), query it interactively, and fuzz fields for NoSQL/SQL injection vectors, thereby revealing hidden attack surfaces. GraphQL endpoints represent a relatively newer attack vector compared to REST, and GraphQLmap helps bridge this gap by providing tooling tailored to the GraphQL paradigm. Because many modern applications adopt GraphQL for flexibility, this tool is useful when scanning and attacking API back ends where typical REST-based tools fall short. ... -
21
tabix
Tabix.io UI
...Displays which query is running. Display the number of tables at the database. The icon of the table depends on its engine. List of fields in the table and inserting the field when clicking in the editor. DB selection via double click in the tree, pop-up window about selection. Search in the tree of objects, filtering the tree. Rebuilding the list of databases / tables after the query is executed. -
22
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. -
23
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. -
24
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. -
25
Excel AddIn : In2Sql
ODBC Cloud SQL Explorer. Connection Manager. Query Editor.
https://sourceforge.net/projects/in2sql Video for best usage https://rb.gy/tvl8lk This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data. *Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"
