Showing 495 open source projects for "sql queries"

View related business solutions
  • Demo Series - Small Business Backup By Veeam Icon
    Demo Series - Small Business Backup By Veeam

    Learn how to protect your Microsoft 365 data, with simple, actionable tips today.

    Watch this on-demand demo series and learn how to protect your Microsoft 365 data with clear, simple, actionable steps that are easy to implement for businesses of all sizes.
    Watch Demo Series
  • MongoDB Atlas runs apps anywhere Icon
    MongoDB Atlas runs apps anywhere

    Deploy in 115+ regions with the modern database for every enterprise.

    MongoDB 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.
    Start Free
  • 1
    mycli

    mycli

    CLI for MySQL with auto-completion and syntax highlighting

    mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive.
    Downloads: 8 This Week
    Last Update:
    See Project
  • 2
    Rill

    Rill

    Fast SQL-based BI tool for real-time dashboards and analytics

    Rill is an operational BI tool that turns raw datasets into fast, interactive dashboards using SQL and a code-first approach. It helps data teams move from data lake to insight quickly, without the complexity of traditional BI systems. With an embedded in-memory database powered by DuckDB or ClickHouse, queries run in milliseconds, enabling real-time exploration and analysis. Rill supports local and remote data sources such as CSV, Parquet, S3, and GCS, making it flexible across environments. ...
    Downloads: 10 This Week
    Last Update:
    See Project
  • 3
    DB MCP Server

    DB MCP Server

    A powerful multi-database server implementing the MCP

    The DB MCP Server is a powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases. Built on the FreePeak/cortex framework, it enables execution of SQL queries, transaction management, schema exploration, and performance analysis across different database systems through a unified interface. ​
    Downloads: 1 This Week
    Last Update:
    See Project
  • 4
    sqlsmith

    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.
    Downloads: 1 This Week
    Last Update:
    See Project
  • AI-generated apps that pass security review Icon
    AI-generated apps that pass security review

    Stop waiting on engineering. Build production-ready internal tools with AI—on your company data, in your cloud.

    Retool 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.
    Try Retool free
  • 5
    FerretDB

    FerretDB

    A truly Open Source MongoDB alternative

    ...FerretDB is going to be a perfect solution for those looking for MongoDB development experience available as fully Open Source Software. The core of our solution is a stateless proxy, which converts MongoDB protocol queries to SQL, and uses PostgreSQL as a database engine. This will be compatible with MongoDB drivers, and should work as a drop-in replacement to MongoDB in many cases. Our vision is to enable the open source community and developers to reap the benefits of easy-to-use document databases, while staying away from vendor lock-in, and fauxpen licenses. ...
    Downloads: 49 This Week
    Last Update:
    See Project
  • 6
    MCP Snowflake Server

    MCP Snowflake Server

    A Model Context Protocol (MCP) server implementation

    An MCP server implementation that facilitates database interactions with Snowflake, allowing execution of SQL queries and presentation of data insights as resources. ​
    Downloads: 0 This Week
    Last Update:
    See Project
  • 7
    Knex

    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.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 8
    Anyquery

    Anyquery

    Query anything (GitHub, Notion, +40 more) with SQL and let LLMs

    Anyquery is an open-source SQL query engine designed to allow users to query data from almost any source using a unified SQL interface. The system enables developers and analysts to run SQL queries on files, APIs, applications, and databases without needing separate connectors or query languages for each platform. Built on top of SQLite, the engine uses a plugin architecture that allows it to extend support to dozens of external services and data sources. ...
    Downloads: 1 This Week
    Last Update:
    See Project
  • 9
    Bob

    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.
    Downloads: 0 This Week
    Last Update:
    See Project
  • Earn up to 16% annual interest with Nexo. Icon
    Earn up to 16% annual interest with Nexo.

    Access competitive interest rates on your digital assets.

    Generate interest, borrow against your crypto, and trade a range of cryptocurrencies — all in one platform. Geographic restrictions, eligibility, and terms apply.
    Get started with Nexo.
  • 10
    Pony ORM

    Pony ORM

    Pony Object Relational Mapper

    Pony ORM is a Python ORM that enables developers to write database queries using generator expressions and Pythonic syntax, making code more readable and intuitive. It automatically translates Python expressions into SQL and supports multiple databases including SQLite, MySQL, PostgreSQL, and Oracle. With an emphasis on simplicity and maintainability, Pony ORM is suitable for both small projects and complex applications.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 11
    Ktorm

    Ktorm

    A lightweight ORM framework for Kotlin with strong-typed SQL DSL

    Ktorm is a lightweight and efficient ORM Framework for Kotlin directly based on pure JDBC. It provides strong-typed and flexible SQL DSL and convenient sequence APIs to reduce our duplicated effort on database operations. All the SQL statements, of course, are generated automatically. Ktorm is open source and available under the Apache 2.0 license. Please leave a star if you've found this library helpful.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 12
    Pinot

    Pinot

    Apache Pinot - A realtime distributed OLAP datastore

    ...Apache Pinot supports dimension lookup joins currently. Full SQL join support in Apache Pinot is coming soon. In the interim, full SQL joins can be performed by querying Pinot via the Trino or PrestoDB connector. Apache Pinot provides SQL interface for querying interactively, as well as programmatically via rest-api.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 13
    Noisia

    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.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 14
    Firebird

    Firebird

    Firebird server, client and tools

    Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, MacOS and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981. To enhance the Firebird functionality, IBSurgeon has sponsored the development and now released for public use the free open source "IBSurgeon Full Text Search UDR" to perform full-text search queries within SQL and PSQL. ...
    Downloads: 11 This Week
    Last Update:
    See Project
  • 15
    SQL of Death
    Professional SQL Database Management Tool An application for managing MySQL, PostgreSQL, and SQLite databases with an intuitive GUI.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 16
    EF Core

    EF Core

    Object-database mapper for .NET

    EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. Entity Framework Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with many databases, including SQL Database (on-premises and Azure), SQLite, MySQL, PostgreSQL, and Azure Cosmos DB. To install EF Core, you install the package for the EF Core database provider(s) you want to target. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 17
    DQO Data Quality Operations Center

    DQO Data Quality Operations Center

    Data Quality Operations Center

    ...DQO comes with around 100 predefined data quality checks which helps you monitor the quality of your data. Table and column-level checks which allows writing your own SQL queries. Daily and monthly date partition testing. Data segmentation by up to 9 different data streams. Build-in scheduling. Calculation of data quality KPIs which can be displayed on multiple built-in data quality dashboards.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 18
    Cloudberry

    Cloudberry

    One advanced and mature open-source MPP

    Apache Cloudberry is a distributed real-time analytics engine designed for querying massive social media datasets. It integrates with Apache AsterixDB and supports efficient ad-hoc queries and aggregations across large volumes of data. Cloudberry is especially useful for dashboards, trend analysis, and time-series social data exploration.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 19
    Genji

    Genji

    Document-oriented, embedded SQL database

    Genji is an embedded database written in Go that aims to simplify dealing with data in the modern world. It combines the power of SQL with the versatility of documents to provide a maximum of flexibility with no compromise. Run powerful queries on rich documents with an expressive SQL syntax. Create tables with strict schemas, partial schemas, or no schemas at all to control your data the way you want it. Fully serializable transactions, in-memory mode, memory usage control, and more. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 20
    SQLAlchemy

    SQLAlchemy

    The Database Toolkit for Python

    ...A relationally-oriented query system, exposing the full range of SQL's capabilities explicitly, including joins, subqueries, correlation, and most everything else, in terms of the object model. Writing queries with the ORM uses the same techniques of relational composition you use when writing SQL.
    Downloads: 14 This Week
    Last Update:
    See Project
  • 21
    MyScaleDB

    MyScaleDB

    A @ClickHouse fork that supports high-performance vector search

    MyScaleDB is an open-source SQL vector database designed for building large-scale AI and machine learning applications that require both analytical queries and semantic vector search. The system is built on top of the ClickHouse database engine and extends it with specialized indexing and search capabilities optimized for vector embeddings. This design allows developers to store structured data, unstructured text, and high-dimensional vector embeddings within a single database platform. ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 22
    Supabase Wrappers

    Supabase Wrappers

    Postgres Foreign Data Wrapper development framework in Rust

    Supabase Wrappers is a collection of PostgreSQL extensions (written in Rust) that allow Postgres to interact with external systems like APIs, files, and other databases. It uses Foreign Data Wrappers (FDWs) to treat external resources as if they were native SQL tables, enabling seamless integration with external services directly from SQL queries.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 23
    SmartSql

    SmartSql

    SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis)

    SmartSql is a lightweight, high-performance ORM for .NET inspired by MyBatis. It provides a hybrid approach that separates SQL from application code while supporting dynamic queries, mapping, and caching. With XML or annotation-based configuration, SmartSql is designed to balance control and productivity for .NET developers.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 24
    fleet

    fleet

    Open-source platform for IT, security, and infrastructure teams

    Fleet exposes familiar concepts from traditional MDMs like custom attributes and dynamic grouping, but in a way that lets you work directly with data and events from each native operating system. A device management platform for managing and monitoring endpoints, specifically designed for IT security and compliance teams.
    Downloads: 6 This Week
    Last Update:
    See Project
  • 25
    Aix-DB

    Aix-DB

    Based on the LangChain/LangGraph framework

    ...The system is designed as a ChatBI solution that allows users to query datasets using natural language and receive structured insights, charts, and visualizations automatically. Built on frameworks such as LangChain and LangGraph, Aix-DB integrates retrieval-augmented generation and Text-to-SQL capabilities to convert user questions into executable database queries. The platform supports multiple types of data sources and provides an end-to-end pipeline that includes intent recognition, SQL generation, database execution, and visual presentation of results. Its architecture includes multiple layers such as a web interface, API gateway, AI service layer, and data storage layer that support relational databases, vector stores, graph databases, and file systems.
    Downloads: 0 This Week
    Last Update:
    See Project