Best AI tools for< Use Sql Functions >
20 - AI tool Sites
CodeSquire
CodeSquire is an AI-powered code writing assistant that helps data scientists, engineers, and analysts write code faster and more efficiently. It provides code completions and suggestions as you type, and can even generate entire functions and SQL queries. CodeSquire is available as a Chrome extension and works with Google Colab, BigQuery, and JupyterLab.
Locale
Locale is an AI-powered platform that enables businesses to automate their business processes using AI agents. It allows users to build AI workflows for various business functions such as marketing, sales, payments, and operations. With features like AI workflow builder, drag-and-drop and SQL builders, and integrations with popular tools like Slack and Zendesk, Locale helps in streamlining processes and increasing team productivity. The platform offers advanced features like AI Copilot, drag-&-drop Workflow Builder, SQL for complex Use Cases, and Human-in-the-loop Steps to enhance automation capabilities. Locale has been successfully used by companies to optimize workflows, reduce manual effort, and improve operational efficiency.
TLDR
TLDR is an AI-powered IDE plugin that explains code in plain English. It supports almost all programming languages and helps developers understand complex code by providing quick summaries. The plugin is available in free and paid versions, offering explanations for regular expressions, SQL queries, and codebases. TLDR aims to save time and enhance code comprehension for individuals and organizations, making it easier to work with unfamiliar code and improve productivity.
SQL Genius
SQL Genius is an AI-powered tool that helps you translate English language queries into SQL queries. It is designed to make it easier for non-technical users to access and use SQL databases. With SQL Genius, you can simply type in your question in plain English, and the tool will automatically generate the corresponding SQL query. This can save you a lot of time and effort, and it can also help you to avoid errors.
Monitr
Monitr is a data visualization and analytics platform that allows users to query, visualize, and share data in one place. It helps in tracking key metrics, making data-driven decisions, and breaking down data silos to provide a unified view of data from various sources. Users can create charts and dashboards, connect to different data sources like Postgresql and MySQL, and collaborate with teammates on SQL queries. Monitr's AI features are powered by Meta AI's Llama 3 LLM, enabling the development of powerful and flexible analytics tools for maximizing data utilization.
AI Query
AI Query is a powerful tool that allows users to generate SQL queries in seconds using simple English. With AI Query, anyone can create efficient SQL queries, without even knowing a thing about it. AI Query is easy to use and affordable, making it a great choice for businesses of all sizes.
Mikie.AI
Mikie.AI is an AI-powered tool that allows users to generate SQL queries in seconds using natural language. It simplifies the process of creating efficient SQL queries by leveraging AI technology. Users can define database schemas easily, translate SQL to English, and benefit from simple pricing plans. Mikie.AI aims to make SQL query generation error-free and accessible to all types of users, even those with limited SQL knowledge.
EverSQL
EverSQL is an AI-powered SQL query optimizer and database observability tool that specializes in optimizing PostgreSQL and MySQL databases. It offers automatic SQL query optimization, ongoing performance insights, and cost reduction recommendations. With over 100,000 professionals trusting EverSQL, it aims to save time and improve database performance by making SQL queries faster and more efficient.
Hex
Hex is a collaborative data workspace that provides a variety of tools for working with data, including queries, notebooks, reports, data apps, and AI. It is designed to be easy to use for people of all technical skill levels, and it integrates with a variety of other tools and services. Hex is a powerful tool for data exploration, analysis, and visualization.
Raw Query
Raw Query is a revolutionary tool that allows you to interact with your database using natural language, just like you would chat with a colleague. It's designed to save you time and effort, and make it easier than ever to access and manage your data. With Raw Query, you can query your data, add new data, and update your data, all through a simple chat interface. It's the perfect tool for anyone who wants to get more out of their data, without having to learn complex SQL queries or spend hours building custom tools.
TripleWhale
TripleWhale is a website that provides security services to protect itself from online attacks. It uses Cloudflare to block unauthorized access and ensure the safety of the website. Users may encounter blocks due to various triggers such as submitting specific words or phrases, SQL commands, or malformed data. In such cases, users can contact the site owner to resolve the issue by providing details of the blocked action and the Cloudflare Ray ID.
Genius Sheets
Genius Sheets is a self-service data reporting tool that allows users to connect to data in Excel and Google Sheets and generate reports without the need for SQL or Python. It is designed to be easy to use and provides enterprise-grade security. Genius Sheets is trusted by over 100 companies and has been featured in publications such as Forbes and TechCrunch.
Basedash
Basedash is an AI-powered data visualization and management tool that enables teams to collaborate and share insights from their databases. It offers features such as a user-friendly interface, customizable dashboards, and powerful SQL editing capabilities. Basedash is designed to streamline data exploration, analysis, and decision-making, making it suitable for various use cases, including customer relationship management, product development, and data-driven decision-making.
DataLang
DataLang is a tool that allows you to chat with your databases, expose a specific set of data (using SQL) to train GPT, and then chat with it in natural language. You can also use DataLang to automatically make your SQL views available via API, share it with your privately users, or make it public.
Shaped
Shaped is a cloud-based platform that provides APIs and tools for building and deploying ranking systems. It offers a variety of features to help developers quickly and easily create and manage ranking models, including a multi-connector SQL interface, a real-time feature store, and a library of pre-built models. Shaped is designed to be scalable, cost-efficient, and easy to use, making it a great option for businesses of all sizes.
Motion
Motion is an AI-powered work planning and scheduling tool that helps individuals and teams be more productive and organized. It uses a proprietary algorithm called The Happiness Algorithm to automatically prioritize tasks, schedule meetings, and track progress. Motion integrates with popular calendars, task managers, and other productivity tools, making it easy to use and customize to your workflow. With Motion, you can save time, reduce stress, and achieve your goals more efficiently.
Abacus.AI
Abacus.AI is the world's first AI platform where AI, not humans, build Applied AI agents and systems at scale. Using generative AI and other novel neural net techniques, AI can build LLM apps, gen AI agents, and predictive applied AI systems at scale.
Journey+
Journey+ is an AI-powered image generator that allows users to create high-quality images without using Discord. It offers a range of features such as image generation, image editing, and image blending, making it a powerful tool for designers, marketers, and agencies. Journey+ is easy to use and can be accessed from any desktop device. It is also affordable, with a free trial and a variety of pricing plans to choose from.
MapDeduce
MapDeduce is an AI-powered tool that helps users understand and analyze complex documents. It can be used to summarize documents, extract key information, and identify potential red flags. MapDeduce is designed to save users time and effort by automating the process of document analysis.
UnlimitedGPT
UnlimitedGPT is a free AI tools directory that provides access to a variety of AI-powered tools, including ChatGPT. With UnlimitedGPT, you can use ChatGPT to generate text, translate languages, write code, and more. UnlimitedGPT also provides a directory of other AI tools, such as image generators, video editors, and music composers.
20 - Open Source AI Tools
MyScaleDB
MyScaleDB is a SQL vector database optimized for AI applications, enabling developers to manage and process massive volumes of data efficiently. It offers fast and powerful vector search, filtered search, and SQL-vector join queries, making it fully SQL-compatible. MyScaleDB provides unmatched performance and scalability by leveraging cutting-edge OLAP database architecture and advanced vector algorithms. It is production-ready for AI applications, supporting structured data, text, vector, JSON, geospatial, and time-series data. MyScale Cloud offers fully-managed MyScaleDB with premium features on billion-scale data, making it cost-effective and simpler to use compared to specialized vector databases. Built on top of ClickHouse, MyScaleDB combines structured and vector search efficiently, ensuring high accuracy and performance in filtered search operations.
myscaledb
MyScaleDB is a SQL vector database designed for scalable AI applications, enabling developers to efficiently manage and process massive volumes of data using familiar SQL. It offers fast and efficient vector search, filtered search, and SQL-vector join queries. MyScaleDB is fully SQL-compatible and production-ready for AI applications, providing unmatched performance and scalability through cutting-edge OLAP architecture and advanced vector algorithms. Built on top of ClickHouse, it combines structured and vectorized data management for high accuracy and speed in filtered searches.
SQL-AI-samples
This repository contains samples to help design AI applications using data from an Azure SQL Database. It showcases technical concepts and workflows integrating Azure SQL data with popular AI components both within and outside Azure. The samples cover various AI features such as Azure Cognitive Services, Promptflow, OpenAI, Vanna.AI, Content Moderation, LangChain, and more. Additionally, there are end-to-end samples like Similar Content Finder, Session Conference Assistant, Chatbots, Vectorization, SQL Server Database Development, Redis Vector Search, and Similarity Search with FAISS.
postgresml
PostgresML is a powerful Postgres extension that seamlessly combines data storage and machine learning inference within your database. It enables running machine learning and AI operations directly within PostgreSQL, leveraging GPU acceleration for faster computations, integrating state-of-the-art large language models, providing built-in functions for text processing, enabling efficient similarity search, offering diverse ML algorithms, ensuring high performance, scalability, and security, supporting a wide range of NLP tasks, and seamlessly integrating with existing PostgreSQL tools and client libraries.
chromem-go
chromem-go is an embeddable vector database for Go with a Chroma-like interface and zero third-party dependencies. It enables retrieval augmented generation (RAG) and similar embeddings-based features in Go apps without the need for a separate database. The focus is on simplicity and performance for common use cases, allowing querying of documents with minimal memory allocations. The project is in beta and may introduce breaking changes before v1.0.0.
baml
BAML is a config file format for declaring LLM functions that you can then use in TypeScript or Python. With BAML you can Classify or Extract any structured data using Anthropic, OpenAI or local models (using Ollama) ## Resources ![](https://img.shields.io/discord/1119368998161752075.svg?logo=discord&label=Discord%20Community) [Discord Community](https://discord.gg/boundaryml) ![](https://img.shields.io/twitter/follow/boundaryml?style=social) [Follow us on Twitter](https://twitter.com/boundaryml) * Discord Office Hours - Come ask us anything! We hold office hours most days (9am - 12pm PST). * Documentation - Learn BAML * Documentation - BAML Syntax Reference * Documentation - Prompt engineering tips * Boundary Studio - Observability and more #### Starter projects * BAML + NextJS 14 * BAML + FastAPI + Streaming ## Motivation Calling LLMs in your code is frustrating: * your code uses types everywhere: classes, enums, and arrays * but LLMs speak English, not types BAML makes calling LLMs easy by taking a type-first approach that lives fully in your codebase: 1. Define what your LLM output type is in a .baml file, with rich syntax to describe any field (even enum values) 2. Declare your prompt in the .baml config using those types 3. Add additional LLM config like retries or redundancy 4. Transpile the .baml files to a callable Python or TS function with a type-safe interface. (VSCode extension does this for you automatically). We were inspired by similar patterns for type safety: protobuf and OpenAPI for RPCs, Prisma and SQLAlchemy for databases. BAML guarantees type safety for LLMs and comes with tools to give you a great developer experience: ![](docs/images/v3/prompt_view.gif) Jump to BAML code or how Flexible Parsing works without additional LLM calls. | BAML Tooling | Capabilities | | ----------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | BAML Compiler install | Transpiles BAML code to a native Python / Typescript library (you only need it for development, never for releases) Works on Mac, Windows, Linux ![](https://img.shields.io/badge/Python-3.8+-default?logo=python)![](https://img.shields.io/badge/Typescript-Node_18+-default?logo=typescript) | | VSCode Extension install | Syntax highlighting for BAML files Real-time prompt preview Testing UI | | Boundary Studio open (not open source) | Type-safe observability Labeling |
blendsql
BlendSQL is a superset of SQLite designed for problem decomposition and hybrid question-answering with Large Language Models (LLMs). It allows users to blend operations over heterogeneous data sources like tables, text, and images, combining the structured and interpretable reasoning of SQL with the generalizable reasoning of LLMs. Users can oversee all calls (LLM + SQL) within a unified query language, enabling tasks such as building LLM chatbots for travel planning and answering complex questions by injecting 'ingredients' as callable functions.
sql-eval
This repository contains the code that Defog uses for the evaluation of generated SQL. It's based off the schema from the Spider, but with a new set of hand-selected questions and queries grouped by query category. The testing procedure involves generating a SQL query, running both the 'gold' query and the generated query on their respective database to obtain dataframes with the results, comparing the dataframes using an 'exact' and a 'subset' match, logging these alongside other metrics of interest, and aggregating the results for reporting. The repository provides comprehensive instructions for installing dependencies, starting a Postgres instance, importing data into Postgres, importing data into Snowflake, using private data, implementing a query generator, and running the test with different runners.
pgvecto.rs
pgvecto.rs is a Postgres extension written in Rust that provides vector similarity search functions. It offers ultra-low-latency, high-precision vector search capabilities, including sparse vector search and full-text search. With complete SQL support, async indexing, and easy data management, it simplifies data handling. The extension supports various data types like FP16/INT8, binary vectors, and Matryoshka embeddings. It ensures system performance with production-ready features, high availability, and resource efficiency. Security and permissions are managed through easy access control. The tool allows users to create tables with vector columns, insert vector data, and calculate distances between vectors using different operators. It also supports half-precision floating-point numbers for better performance and memory usage optimization.
indexify
Indexify is an open-source engine for building fast data pipelines for unstructured data (video, audio, images, and documents) using reusable extractors for embedding, transformation, and feature extraction. LLM Applications can query transformed content friendly to LLMs by semantic search and SQL queries. Indexify keeps vector databases and structured databases (PostgreSQL) updated by automatically invoking the pipelines as new data is ingested into the system from external data sources. **Why use Indexify** * Makes Unstructured Data **Queryable** with **SQL** and **Semantic Search** * **Real-Time** Extraction Engine to keep indexes **automatically** updated as new data is ingested. * Create **Extraction Graph** to describe **data transformation** and extraction of **embedding** and **structured extraction**. * **Incremental Extraction** and **Selective Deletion** when content is deleted or updated. * **Extractor SDK** allows adding new extraction capabilities, and many readily available extractors for **PDF**, **Image**, and **Video** indexing and extraction. * Works with **any LLM Framework** including **Langchain**, **DSPy**, etc. * Runs on your laptop during **prototyping** and also scales to **1000s of machines** on the cloud. * Works with many **Blob Stores**, **Vector Stores**, and **Structured Databases** * We have even **Open Sourced Automation** to deploy to Kubernetes in production.
pgai
pgai simplifies the process of building search and Retrieval Augmented Generation (RAG) AI applications with PostgreSQL. It brings embedding and generation AI models closer to the database, allowing users to create embeddings, retrieve LLM chat completions, reason over data for classification, summarization, and data enrichment directly from within PostgreSQL in a SQL query. The tool requires an OpenAI API key and a PostgreSQL client to enable AI functionality in the database. Users can install pgai from source, run it in a pre-built Docker container, or enable it in a Timescale Cloud service. The tool provides functions to handle API keys using psql or Python, and offers various AI functionalities like tokenizing, detokenizing, embedding, chat completion, and content moderation.
yudao-boot-mini
yudao-boot-mini is an open-source project focused on developing a rapid development platform for developers in China. It includes features like system functions, infrastructure, member center, data reports, workflow, mall system, WeChat official account, CRM, ERP, etc. The project is based on Spring Boot with Java backend and Vue for frontend. It offers various functionalities such as user management, role management, menu management, department management, workflow management, payment system, code generation, API documentation, database documentation, file service, WebSocket integration, message queue, Java monitoring, and more. The project is licensed under the MIT License, allowing both individuals and enterprises to use it freely without restrictions.
langroid
Langroid is a Python framework that makes it easy to build LLM-powered applications. It uses a multi-agent paradigm inspired by the Actor Framework, where you set up Agents, equip them with optional components (LLM, vector-store and tools/functions), assign them tasks, and have them collaboratively solve a problem by exchanging messages. Langroid is a fresh take on LLM app-development, where considerable thought has gone into simplifying the developer experience; it does not use Langchain.
vectordb-recipes
This repository contains examples, applications, starter code, & tutorials to help you kickstart your GenAI projects. * These are built using LanceDB, a free, open-source, serverless vectorDB that **requires no setup**. * It **integrates into python data ecosystem** so you can simply start using these in your existing data pipelines in pandas, arrow, pydantic etc. * LanceDB has **native Typescript SDK** using which you can **run vector search** in serverless functions! This repository is divided into 3 sections: - Examples - Get right into the code with minimal introduction, aimed at getting you from an idea to PoC within minutes! - Applications - Ready to use Python and web apps using applied LLMs, VectorDB and GenAI tools - Tutorials - A curated list of tutorials, blogs, Colabs and courses to get you started with GenAI in greater depth.
Agently
Agently is a development framework that helps developers build AI agent native application really fast. You can use and build AI agent in your code in an extremely simple way. You can create an AI agent instance then interact with it like calling a function in very few codes like this below. Click the run button below and witness the magic. It's just that simple: python # Import and Init Settings import Agently agent = Agently.create_agent() agent\ .set_settings("current_model", "OpenAI")\ .set_settings("model.OpenAI.auth", {"api_key": ""}) # Interact with the agent instance like calling a function result = agent\ .input("Give me 3 words")\ .output([("String", "one word")])\ .start() print(result) ['apple', 'banana', 'carrot'] And you may notice that when we print the value of `result`, the value is a `list` just like the format of parameter we put into the `.output()`. In Agently framework we've done a lot of work like this to make it easier for application developers to integrate Agent instances into their business code. This will allow application developers to focus on how to build their business logic instead of figure out how to cater to language models or how to keep models satisfied.
llmops-duke-aipi
LLMOps Duke AIPI is a course focused on operationalizing Large Language Models, teaching methodologies for developing applications using software development best practices with large language models. The course covers various topics such as generative AI concepts, setting up development environments, interacting with large language models, using local large language models, applied solutions with LLMs, extensibility using plugins and functions, retrieval augmented generation, introduction to Python web frameworks for APIs, DevOps principles, deploying machine learning APIs, LLM platforms, and final presentations. Students will learn to build, share, and present portfolios using Github, YouTube, and Linkedin, as well as develop non-linear life-long learning skills. Prerequisites include basic Linux and programming skills, with coursework available in Python or Rust. Additional resources and references are provided for further learning and exploration.
lantern
Lantern is an open-source PostgreSQL database extension designed to store vector data, generate embeddings, and handle vector search operations efficiently. It introduces a new index type called 'lantern_hnsw' for vector columns, which speeds up 'ORDER BY ... LIMIT' queries. Lantern utilizes the state-of-the-art HNSW implementation called usearch. Users can easily install Lantern using Docker, Homebrew, or precompiled binaries. The tool supports various distance functions, index construction parameters, and operator classes for efficient querying. Lantern offers features like embedding generation, interoperability with pgvector, parallel index creation, and external index graph generation. It aims to provide superior performance metrics compared to other similar tools and has a roadmap for future enhancements such as cloud-hosted version, hardware-accelerated distance metrics, industry-specific application templates, and support for version control and A/B testing of embeddings.
AirGo
AirGo is a front and rear end separation, multi user, multi protocol proxy service management system, simple and easy to use. It supports vless, vmess, shadowsocks, and hysteria2.
20 - OpenAI Gpts
Use Case Writing Assistant
This GPT can generate software use cases, which are based on a use case templates repository and conform to a style guide.
ecosystem.Ai Use Case Designer v2
The use case designer is configured with the latest Data Science and Behavioral Social Science insights to guide you through the process of defining AI and Machine Learning use cases for the ecosystem.Ai platform.
AI Use Case Analyst for Sales & Marketing
Enables sales & marketing leadership to identify high-value AI use cases
Terms of Use & Privacy policy Assistant
OpenAIのTerms of UseとPrivacy policyを参照できます(2023年12月14日適用分)
PragmaPilot - A Generative AI Use Case Generator
Show me your job description or just describe what you do professionally, and I'll help you identify high value use cases for AI in your day-to-day work. I'll also coach you on simple techniques to get the best out of ChatGPT.
Name Generator and Use Checker Toolkit
Need a new name? Character, brand, story, etc? Try the matrix! Use all the different naming modules as different strategies for new names!
Your Headline Writer
Use this to get increased engagement, more clicks and higher rankings for your content. Copy and paste your headline below and get a score out of 100 and 3 new ideas on how to improve it. For FREE.
Write a romance novel
Use this GPT to outline your romance novel: design your story, your characters, obstacles, stakes, twists, arena, etc… Then ask GPT to draft the chapters ❤️ (remember: you are the brain, GPT is just the hand. Stay creative, use this GPT as an author!)
IHeartDomains.BOT | Web3 Domain Knowledgebase
Use me for educational insights, ALPHA, and strategies for investing in Domains & Digital Identity. Your GUIDE to Unstoppable Domains, ENS, Freename, HNS, and more. *DO NOT use as Financial Advice & Always DYOR* https://iheartdomains.com
Acquisition Criteria Creator
Use me to help you decide what type of business to acquire. Let's go!
Family Constellation Guide
Use DALL-E to create a family constellation image for an issue that has been troubling you.
The 80/20 Principle master(80/20法则大师-敏睿)
使用GPTS快速识别关键因素,提高决策效率和工作效率,找到关键的20%,Use GPTS to quickly identify key factors, improve decision-making efficiency and work efficiency, and find the key 20%.