Search Results for "sql sorting queries"
Sort By:
Showing 26 open source projects for "sql sorting queries"
View related business solutions-
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.
-
Cut Data Warehouse Costs by 54%BigQuery delivers 54% lower TCO with exabyte scale and flexible pricing. Free migration tools handle the SQL translation automatically.
-
1
SQL Formatter
A whitespace formatter for different query languages
SQL Formatter is a JavaScript library for pretty-printing SQL queries. It started as a port of a PHP Library, but has since considerably diverged. It supports various SQL dialects: GCP BigQuery, IBM DB2, Apache Hive, MariaDB, MySQL, Couchbase N1QL, Oracle PL/SQL, PostgreSQL, Amazon Redshift, SingleStoreDB, Snowflake, Spark, SQL Server Transact-SQL, Trino/Presto. -
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
SafeQL
Validate and auto-generate TypeScript types from raw SQL queries
...SafeQL is an ESLint plugin that helps you write SQL (PostgreSQL) queries safely. SafeQL was never meant to replace your current SQL library. Instead, It's a plugin that you can use to add extra functionality to your existing SQL library. It means that you can use SafeQL with any SQL library that you want. You can even use SafeQL with multiple SQL libraries at the same time. -
4
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. -
Paessler: Easy to Use With Enterprise Power. Free TrialYou shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
-
5
TailwindSQL
TailwindSQL lets you write SQL queries using Tailwind-style class name
TailwindSQL is an experimental library that lets developers write SQL queries using Tailwind-style class names, essentially turning database queries into declarative class attributes that can be used directly in frameworks like React Server Components. Inspired by the simplicity and utility of Tailwind CSS, TailwindSQL allows developers to describe database queries using a familiar syntax such as db-table-column-where-field-value, collapsing traditional SQL into readable, utility-driven structures that map directly to data fetches. ... -
6
AIOStreams
One addon to rule them all
AIOStreams is a “super-add-on” for Stremio that consolidates results from many add-ons and debrid services into a single, customizable feed. Instead of juggling multiple add-ons, you point AIOStreams at them; it then queries, merges, de-duplicates, and re-ranks everything according to your rules. The project includes a powerful filtering and sorting engine—think conditions on resolution, codec, provider, cached status, seed count, and more—so power users can shape results precisely. It also provides a template-based formatter to control how streams are labeled in the UI, complete with live preview for quick iteration. ... -
7
MCP Server MySQL
A Model Context Protocol server
A Model Context Protocol server that provides access to MySQL databases, enabling Large Language Models to inspect database schemas and execute SQL queries, facilitating seamless database interactions. -
8
WrenAI
Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy
...With Wren AI, you can process metadata, schema, terminology, data relationships, and the logic behind calculations and aggregations with “Modeling Definition Language”, to generate accurate SQL queries with semantic context. When starting a new conversation in Wren AI, your question is used to find the most relevant tables. From these, LLM generates three relevant questions for the user to choose from. You can also ask follow-up questions to get deeper insights. -
9
match-sorter
Simple, expected, and deterministic best-match sorting
match-sorter is a small JavaScript library that takes a list of items and returns them sorted by how well they match a given search query. It is designed to produce “simple, expected, and deterministic” results so users see intuitive matches instead of opaque fuzzy scores. The core API accepts arrays of strings or objects and returns a filtered, ranked list, making it a natural fit for search boxes, autocomplete components, and table filtering. It supports a variety of advanced options, such... -
Build Data Resilience - Take the Assessment TodayIs your recovery strategy as strong as you think? Take this quick self-assessment to check your recovery readiness and gain tailored insights. In only 2 minutes, you'll learn where you fall on the recovery readiness scale.
-
10
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. ... -
11
Mathesar
An intuitive spreadsheet-like interface
Mathesar is an open-source platform designed to make databases accessible to non-technical users. It offers an intuitive spreadsheet-like interface on top of PostgreSQL, allowing users to create, edit, and analyze structured data without writing SQL. Built with user experience in mind, Mathesar empowers teams to collaborate on data-driven workflows while retaining the power of a real relational database. -
12
dataline
AI data analysis and visualization on CSV, Postgres, MySQL, Snowflake
dataline is an open-source AI data analysis and visualization platform that allows users to interact with datasets using natural language. The system enables both technical and non-technical users to explore data by asking questions conversationally, which the platform translates into database queries and analytical operations. It supports connections to multiple structured data sources such as PostgreSQL, MySQL, Snowflake, SQLite, Excel files, CSV datasets, and other database systems. Once... -
13
NetPad
A cross-platform C# editor and playground
A cross-platform C# editor and playground. NetPad is a C# playground that lets you run C# code instantly, without the hassle of creating and managing projects. Open NetPad, start coding, hit Run, and see your output immediately. It's that simple. Quickly prototype and test code snippets before incorporating them into your projects. Visualize data interactively for better insights and analysis. Query databases using LINQ or SQL effortlessly. Experiment with new C# features or start learning... -
14
Localflare
local cloudflare
...Instead of juggling multiple CLIs and scattered logs, it gives you a unified UI for common Cloudflare primitives like D1 databases, KV namespaces, R2 buckets, Durable Objects, and Queues. The D1 experience is more than a viewer: it includes a SQL editor and a data browser with inline editing, filtering, sorting, bulk operations, and even dummy data generation so you can iterate quickly. For KV and R2 it provides practical file-and-record management, letting you view, update, delete, upload, and download as part of your normal dev loop. It also includes tools for testing queue behavior by sending messages and inspecting results, which helps validate event-driven logic without deploying. -
15
Outerbase
A lightweight Database GUI in your browser
Outerbase Studio is an open-source, browser-based database GUI designed for simplicity and versatility. It supports connecting to various relational databases, providing an intuitive interface for managing and querying data without the need for complex setups. -
16
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... -
17
TypeScript Express Starter
Quick and Easy TypeScript Express Starter
Express consists of JavaScript, which makes it vulnerable to type definitions. That's why we avoid supersets with starter packages that introduce TypeScript. The package is configured to use TypeScript instead of JavaScript. Express is a fast, open and concise web framework and is a Node.js based project. npx is a tool in the JavaScript package management module, npm. This is a tool that allows you to run the npm package on a single run without installing the package. If you do not enter a... -
18
Mikro Orm
TypeScript ORM for Node.js based on Data Mapper, Unit of Work
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. MikroORM allows handling transactions automatically. When you call em.flush(), all computed changes are wrapped inside a database transaction. Uses source code analysis so you do not have to repeat yourself when defining entities. Simply define correct TypeScript types and you are good to go! Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases, and more can be supported via custom drivers... -
19
tabularis
An open-source desktop client for modern databases.
...ER Diagram visualization. SSH tunneling. Secure credential storage via OS keychain. Split view, saved queries, SQL dump/import, 10+ themes, customizable shortcuts. Hackable, extensible, and built for everyday SQL work. https://tabularis.dev https://github.com/debba/tabularis -
20
VulcanSQL
Data API Framework for AI Agents and Data Apps
Vulcan SQL is a modern data API framework that lets you build secure and scalable data APIs directly from SQL files. Designed for data teams, it allows the definition of parameterized queries, policy enforcement, and transformation layers using familiar SQL syntax. Vulcan SQL integrates with BI tools and data warehouses, making it easy to expose internal datasets as RESTful APIs. -
21
Kurier
TypeScript framework to create JSON:API compliant APIs
...Baked into Kurier, there is an operation processor that takes care of basic CRUD actions by using Knex. This allows the framework to support any database engine compatible with Knex. Also includes support for filtering fields by using common SQL operators, sorting and pagination. -
22
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. -
23
nestjs-query
Easy CRUD for GraphQL.
NestJS Query is a library for building GraphQL or REST APIs with querying and filtering capabilities, simplifying CRUD operations within NestJS applications. -
24
Microsoft Azure Cosmos JavaScript SDK
JavaScript & Node.js SDK library for SQL API of Azure Cosmos Database
Azure Cosmos JS is the official JavaScript SDK for interacting with Azure Cosmos DB, Microsoft's globally distributed, multi-model database service. It provides developers with an easy-to-use API to manage databases, collections, and documents using Node.js and browser-based applications. The SDK supports querying, transactions, and scalability for high-performance applications. -
25
Monorepo for nanoSQL 2.0
Universal database layer for the client, server & mobile devices
Nano-SQL is a lightweight, cross-platform database that offers NoSQL and SQL-like querying for JavaScript applications, working both in-browser and server-side.
