Search Results for "sql query"
Sort By:
Showing 28 open source projects for "sql query"
View related business solutions-
AestheticsPro Medical Spa SoftwareAestheticsPro is the most complete Aesthetics Software on the market today. HIPAA Cloud Compliant with electronic charting, integrated POS, targeted marketing and results driven reporting; AestheticsPro delivers the tools you need to manage your medical spa business. It is our mission To Provide an All-in-One Cutting Edge Software to the Aesthetics Industry.
-
Skillfully - The future of skills based hiringSkillfully transforms hiring through AI-powered skill simulations that show you how candidates actually perform before you hire them. Our platform helps companies cut through AI-generated resumes and rehearsed interviews by validating real capabilities in action. Through dynamic job specific simulations and skill-based assessments, companies like Bloomberg and McKinsey have cut screening time by 50% while dramatically improving hire quality.
-
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
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. See language option docs for more details. The CLI tool will be installed under sql-formatter and may be invoked via npx... -
3
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. -
4
Slonik
A Node.js PostgreSQL client with runtime and build time type safety
Slonik is a PostgreSQL client for Node.js that ensures safe and efficient query execution by using tagged template literals, preventing SQL injection attacks and promoting better query structure. -
Simplify Purchasing For Your BusinessSimplify every aspect of buying for your business in Order.co. From sourcing products to scaling purchasing across locations to automating your AP and approvals workstreams, Order.co is the platform of choice for growing businesses.
-
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
Better Stack JavaScript client
Better Stack JavaScript client
...Get answers fast with a powerful SQL query builder. No need to learn a new querying language or ask your data analyst. -
7
ChartDB
Database diagrams editor to visualize and design your DB
ChartDB is a web-based database diagramming editor that allows users to visualize and design their database schemas with a single "Smart Query." It offers instant schema import, customization options, and the ability to export SQL scripts, all without requiring an account. ChartDB is ideal for developers and teams looking to streamline database design and documentation. -
8
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. -
9
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. -
Award-Winning Medical Office Software Designed for Your SpecialtyRXNT is an ambulatory healthcare technology pioneer that empowers medical practices and healthcare organizations to succeed and scale through innovative, data-backed, AI-powered software.
-
10
SafeQL
Validate and auto-generate TypeScript types from raw SQL queries
SafeQL is an ESLint plugin for writing SQL queries in a type-safe way. SafeQL automatically infers the type of the query result based on the query itself. SafeQL works with any PostgreSQL client, including Prisma, Sequelize, pg, Postgres.js, and more. SafeQL was built in mind to be easy to use and integrate with your existing codebase. SafeQL was built with monorepos and microservices in mind, and it's easy to use with multiple databases. -
11
Rill
Fast SQL-based BI tool for real-time dashboards and analytics
...Its BI-as-code model combines SQL, YAML configuration, Git version control, and CLI tools, allowing teams to build, manage, and deploy analytics workflows efficiently. Automatic data profiling and responsive query updates help users understand datasets instantly. Interactive dashboards come with opinionated defaults, so teams can focus on insights instead of setup, while metrics layers standardize business logic for consistent reporting across dashboards, APIs, and AI systems. -
12
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. -
13
WrenAI
Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy
Wren AI is a SQL AI Agent for data teams to get results and insights faster by asking business questions without writing SQL, and it's open-source. Wren AI has implemented a semantic engine architecture to provide the LLM context of your business; you can easily establish a logical presentation layer on your data schema that helps LLM learn more about your business context. With Wren AI, you can process metadata, schema, terminology, data relationships, and the logic behind calculations and... -
14
DbGate
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application. DbGate is a cross-platform database manager. It's designed to be simple to use and effective when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualization or batch export and import. -
15
ChatLab
Local-first AI chat analysis tool for insights from conversation data
...It enables users to import chat exports from multiple messaging platforms and transform them into a unified data model for consistent analysis. By combining a flexible SQL engine with AI agents, the tool allows users to query, summarize, and explore conversation patterns in a more interactive and intelligent way. ChatLab emphasizes a local-first approach, meaning all chat data is processed and stored on the user’s device rather than being uploaded to external servers. It supports large-scale datasets through streaming parsing and multi-worker processing, allowing it to handle millions of messages efficiently. ... -
16
Prisma
Next-generation ORM for Node.js and TypeScript
...Central to Prisma is the schema, a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that. Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. We designed the API to be intuitive for both SQL veterans and people brand new to databases. Auto-completion, linting, formatting and more help Prisma developers in VSCode stay confident without distractions. Prisma Client puts extra emphasis on extensive type safety for more productive development in TypeScript. ... -
17
NetPad
A cross-platform C# editor and playground
...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 C# in an intuitive and accessible environment. Create and save your own utility or administration scripts for repeated use. -
18
DBHub
Universal database MCP server connecting to MySQL, PostgreSQL
DBHub is a universal database gateway that implements the MCP server interface so assistants and IDEs can explore and query databases through typed tools. It supports multiple transports—stdio for desktop clients and HTTP for networked scenarios—making it flexible to embed or deploy. Configuration is environment-variable driven, with a DSN and per-engine settings covering Postgres, MySQL, MariaDB, SQL Server, and SQLite. Operational flags include read-only mode, row limits, and even SSH tunneling options for secure access into private networks. ... -
19
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... -
20
create-t3-app
The best way to start a full-stack, typesafe Next.js app
...It's the industry standard and we're proud to build on top of it :) Prisma is the best way to work with databases in TypeScript. It provides a simple, type-safe API to query your database, and it can be used with most SQL dialects (and Mongo too!). We firmly believe TypeScript will help you be a better web developer. -
21
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... -
22
tabularis
An open-source desktop client for modern databases.
Tabularis is a free, open-source desktop database client for PostgreSQL, MySQL/MariaDB, and SQLite. Built with Rust and Tauri v2, it is fast, lightweight, and cross-platform (Windows, macOS, Linux). Features: SQL Notebooks with inline charts and cross-cell variables. AI-powered SQL assistant (OpenAI, Claude, Ollama, and more). Built-in MCP server for AI agent integration. Visual Query Builder with drag-and-drop JOINs. Plugin system to add any database driver. Monaco-based editor with smart autocomplete. High-performance data grid with inline editing. ... -
23
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. -
24
DataStation Community Edition
App to easily query, script, and visualize data from every database
DataStation is an open-source data IDE for developers. It allows you to easily build graphs and tables with data pulled from SQL databases, logging databases, metrics databases, HTTP servers, and all kinds of text and binary files. Need to join or munge data? Write embedded scripts as needed in languages like Python, JavaScript, R or SQL. All in one application. Build reports with graphs, charts and tables. Script against data. Cross-platform: Windows, macOS, and Linux. Easily fetch your... -
25
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.
