Best AI tools for< Query Local Data >

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.

Query Kitty is a Chrome extension that allows users to access ChatGPT from anywhere on the web. It provides a variety of features to help users get the most out of ChatGPT, including pre-written prompts, the ability to use web pages as context for prompts, and unlimited translations. Query Kitty is available in three plans: Starter, Basic, and Pro. The Starter plan is free and includes 60,000 words per month, the Basic plan costs $6 per month and includes 75,000 words per month, and the Pro plan costs $24 per month and includes 300,000 words per month. All plans come with a 3-day free trial.

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.

Accio is a data modeling tool that allows users to define consistent relationships, metrics, and expressions for on-the-fly computations in reports and dashboards across various BI tools. It provides a syntax similar to GraphQL that allows users to define models, relationships, and metrics in a human-readable format. Accio also offers a user-friendly interface that provides data analysts with a holistic view of the relationships between their data models, enabling them to grasp the interconnectedness and dependencies within their data ecosystem. Additionally, Accio utilizes DuckDB as a caching layer to accelerate query performance for BI tools.

SQLPilot is an AI-first SQL editor that leverages artificial intelligence to help users quickly generate complex SQL queries. The tool supports multiple GPT models, offers SQL autocomplete, ensures privacy and security by not storing user data, and allows users to download query results in CSV format. With SQLPilot, users can write prompts in natural language, mention required tables, and let the AI model generate the query with all the necessary context. Testimonials from users highlight the tool's efficiency, accuracy, and time-saving capabilities in database management.

QueryHub is an AI-powered web application designed to assist students in their academic endeavors. It provides a platform for users to ask and answer questions, collaborate with peers, and access instant and accurate information through AI chatbot assistance and smart search capabilities. QueryHub aims to empower students by offering a personalized learning experience, accelerating learning through document collaboration, and fostering community collaboration. With a user-friendly interface and a focus on user-driven innovation, QueryHub is a valuable tool for enhancing academic success.

AutoQuery GPT is a tool that allows users to ask questions to ChatGPT and get answers automatically. It provides users with time-saving and performance benefits. Users can use this site by using their own API key to ask questions to ChatGPT and save the answers as a file, using the Query Block and Query Excel features.

BixGPT is an AI-powered tool designed to supercharge product documentation by leveraging the power of private AI models. It offers features like AI-assisted release notes generation, data encryption, autodiscovery of Jira data, multi-format support, client notifications, and more. With BixGPT, users can create and manage release notes effortlessly while ensuring data privacy and security through the use of private AI models. The tool provides a seamless experience for generating release web pages with custom styling and analytics.

Code99 is an AI-powered platform designed to speed up the development process by generating instant boilerplate code. It allows users to customize their tech stack, streamline development, and launch projects faster. Ideal for startups, developers, and IT agencies looking to accelerate project timelines and improve productivity.

Equals is a next-generation analysis and reporting tool designed to help startups and businesses make better decisions with their data. It offers features such as live data connections, full-featured spreadsheets, and BI-grade dashboards. Equals bridges the gap between one-size-fits-all solutions and complex data platforms, providing users with a familiar and flexible environment for data exploration and reporting.

AI2SQL is an AI-powered SQL query builder and generator that allows users to create, optimize, and automate SQL queries without the need for expert skills. The tool transforms natural language instructions into precise SQL and NoSQL queries, simplifying database design and enhancing query performance. With features like Text2SQL, SQL Query Fixer, SQL Query Explainer, and SQL Query Optimizer, AI2SQL offers a streamlined solution for diverse SQL tasks. Trusted by industry leaders, AI2SQL saves time, reduces errors, and improves productivity for data analysts and developers.

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.

AnyAPI is an AI tool that allows users to easily add AI features to their products in minutes. With the ability to craft the perfect GPT-3 prompt using A/B testing, users can quickly generate a live API endpoint to power their next AI feature. The platform offers a range of use cases, including turning emails into tasks, suggesting replies, and accessing plain text JSON. AnyAPI is designed to streamline the integration of AI capabilities into various products and services, making it a valuable tool for developers and businesses seeking to enhance their offerings with AI technology.

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.

SQL Builder is an AI-powered SQL query generator that allows users to easily generate complex SQL queries without writing any code. It offers a range of features such as a no-code SQL builder, SQL syntax explainer, SQL optimizer, SQL formatter, NoSQL query builder, and SQL syntax validator. SQL Builder supports various databases including MySQL, MariaDB, SQLite, PostgreSQL, Oracle, Microsoft SQL Server, MongoDB, BigQuery, Snowflake, and Amazon Redshift.

Legalyze.ai is an AI-powered platform designed to assist lawyers in streamlining their document review process. It uses AI to summarize and extract key points from case documents, providing rapid insights, summaries, and answers to specific questions. The platform allows users to create document summaries in seconds, supports various file formats, and is externally security audited. Legalyze.ai aims to save time for legal professionals by automating tasks like fact-finding and document creation.

WebDB is an open-source and efficient Database IDE that focuses on providing a secure and user-friendly platform for database management. It offers features such as automatic DBMS discovery, credential guessing, time machine for database version control, powerful queries editor with autocomplete and documentation, AI assistant integration, NoSQL structure management, intelligent data generation, and more. With a modern ERD view and support for various databases, WebDB aims to simplify database management tasks and enhance productivity for users.

LINQ Me Up is an AI-powered tool designed to boost .Net productivity by generating and converting LINQ queries efficiently. It offers fast and reliable conversion of SQL queries to LINQ code, transformation of LINQ code into SQL queries, and tailored LINQ queries for various datasets. The tool supports C# and Visual Basic code, Method and Query syntax, and utilizes AI-powered analysis for optimized results. LINQ Me Up is more versatile and powerful than rule-based or syntax conversions, enabling users to effortlessly migrate, build, and focus on essential code parts.

GPT Excel is an AI-powered tool that helps users generate spreadsheet formulas, SQL queries, Apps Script and VBA scripts easily. It supports over 50 languages and offers a free tier with limited requests per day. The pro plan includes additional features such as unlimited requests, priority customer support, and access to additional AI tools like a regex generator and an Excel template generator.

scatteredNote is an AI-powered note-taking application designed to help users effortlessly grab content and take notes while focusing on their main tasks. The application aims to make note-taking a seamless by-product of the user's main activities, ensuring minimal distraction. With features like Atomic Embrace mental model, Extended memory with AI integration, and simple UI, scatteredNote offers a user-friendly experience for organizing and accessing archived knowledge. The application supports various capture modes, including YouTube Capture, VS-Code Capture, Web-mode Capture, and Pdf-mode capture, along with AI chat and Ai-space repetition functionalities. Users can easily organize their notes, create flashcards, and access information quickly with the help of AI technology.

Polymarket Agents is a developer framework and set of utilities for building AI agents to trade autonomously on Polymarket. It integrates with Polymarket API, provides AI agent utilities for prediction markets, supports local and remote RAG, sources data from various services, and offers comprehensive LLM tools for prompt engineering. The architecture features modular components like APIs and scripts for managing local environments, server set-up, and CLI for end-user commands.

LLMChat is an all-in-one AI chat interface that supports multiple language models, offers a plugin library for enhanced functionality, enables web search capabilities, allows customization of AI assistants, provides text-to-speech conversion, ensures secure local data storage, and facilitates data import/export. It also includes features like knowledge spaces, prompt library, personalization, and can be installed as a Progressive Web App (PWA). The tech stack includes Next.js, TypeScript, Pglite, LangChain, Zustand, React Query, Supabase, Tailwind CSS, Framer Motion, Shadcn, and Tiptap. The roadmap includes upcoming features like speech-to-text and knowledge spaces.

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.

Home-Gallery.org is a self-hosted open-source web gallery for browsing personal photos and videos with tagging, mobile-friendly interface, and AI-powered image and face discovery. It aims to provide a fast user experience on mobile phones and help users browse and rediscover memories from their media archive. The tool allows users to serve their local data without relying on cloud services, view photos and videos from mobile phones, and manage images from multiple media source directories. Features include endless photo stream, video transcoding, reverse image lookup, face detection, GEO location reverse lookups, tagging, and more. The tool runs on NodeJS and supports various platforms like Linux, Mac, and Windows.

Swirl is an open-source software that allows users to simultaneously search multiple content sources and receive AI-ranked results. It connects to various data sources, including databases, public data services, and enterprise sources, and utilizes AI and LLMs to generate insights and answers based on the user's data. Swirl is easy to use, requiring only the download of a YML file, starting in Docker, and searching with Swirl. Users can add credentials to preloaded SearchProviders to access more sources. Swirl also offers integration with ChatGPT as a configured AI model. It adapts and distributes user queries to anything with a search API, re-ranking the unified results using Large Language Models without extracting or indexing anything. Swirl includes five Google Programmable Search Engines (PSEs) to get users up and running quickly. Key features of Swirl include Microsoft 365 integration, SearchProvider configurations, query adaptation, synchronous or asynchronous search federation, optional subscribe feature, pipelining of Processor stages, results stored in SQLite3 or PostgreSQL, built-in Query Transformation support, matching on word stems and handling of stopwords, duplicate detection, re-ranking of unified results using Cosine Vector Similarity, result mixers, page through all results requested, sample data sets, optional spell correction, optional search/result expiration service, easily extensible Connector and Mixer objects, and a welcoming community for collaboration and support.

Screen-pipe is a Rust + WASM tool that allows users to turn their screen into actions using Large Language Models (LLMs). It enables users to record their screen 24/7, extract text from frames, and process text and images for tasks like analyzing sales conversations. The tool is still experimental and aims to simplify the process of recording screens, extracting text, and integrating with various APIs for tasks such as filling CRM data based on screen activities. The project is open-source and welcomes contributions to enhance its functionalities and usability.

HybridAGI is the first Programmable LLM-based Autonomous Agent that lets you program its behavior using a **graph-based prompt programming** approach. This state-of-the-art feature allows the AGI to efficiently use any tool while controlling the long-term behavior of the agent. Become the _first Prompt Programmers in history_ ; be a part of the AI revolution one node at a time! **Disclaimer: We are currently in the process of upgrading the codebase to integrate DSPy**

LangChain is an amazing framework to get LLM projects done in a matter of no time, and the ecosystem is growing fast. Here is an attempt to keep track of the initiatives around LangChain. Subscribe to the newsletter to stay informed about the Awesome LangChain. We send a couple of emails per month about the articles, videos, projects, and tools that grabbed our attention Contributions welcome. Add links through pull requests or create an issue to start a discussion. Please read the contribution guidelines before contributing.

Sparrow is an innovative open-source solution for efficient data extraction and processing from various documents and images. It seamlessly handles forms, invoices, receipts, and other unstructured data sources. Sparrow stands out with its modular architecture, offering independent services and pipelines all optimized for robust performance. One of the critical functionalities of Sparrow - pluggable architecture. You can easily integrate and run data extraction pipelines using tools and frameworks like LlamaIndex, Haystack, or Unstructured. Sparrow enables local LLM data extraction pipelines through Ollama or Apple MLX. With Sparrow solution you get API, which helps to process and transform your data into structured output, ready to be integrated with custom workflows. Sparrow Agents - with Sparrow you can build independent LLM agents, and use API to invoke them from your system. **List of available agents:** * **llamaindex** - RAG pipeline with LlamaIndex for PDF processing * **vllamaindex** - RAG pipeline with LLamaIndex multimodal for image processing * **vprocessor** - RAG pipeline with OCR and LlamaIndex for image processing * **haystack** - RAG pipeline with Haystack for PDF processing * **fcall** - Function call pipeline * **unstructured-light** - RAG pipeline with Unstructured and LangChain, supports PDF and image processing * **unstructured** - RAG pipeline with Weaviate vector DB query, Unstructured and LangChain, supports PDF and image processing * **instructor** - RAG pipeline with Unstructured and Instructor libraries, supports PDF and image processing. Works great for JSON response generation

GraphRAG Local with Interactive UI is an adaptation of Microsoft's GraphRAG, tailored to support local models and featuring a comprehensive interactive user interface. It allows users to leverage local models for LLM and embeddings, visualize knowledge graphs in 2D or 3D, manage files, settings, and queries, and explore indexing outputs. The tool aims to be cost-effective by eliminating dependency on costly cloud-based models and offers flexible querying options for global, local, and direct chat queries.

RAG with txtai is a Retrieval Augmented Generation (RAG) Streamlit application that helps generate factually correct content by limiting the context in which a Large Language Model (LLM) can generate answers. It supports two categories of RAG: Vector RAG, where context is supplied via a vector search query, and Graph RAG, where context is supplied via a graph path traversal query. The application allows users to run queries, add data to the index, and configure various parameters to control its behavior.

RAG Me Up is a generic framework that enables users to perform Retrieve and Generate (RAG) on their own dataset easily. It consists of a small server and UIs for communication. Best run on GPU with 16GB vRAM. Users can combine RAG with fine-tuning using LLaMa2Lang repository. The tool allows configuration for LLM, data, LLM parameters, prompt, and document splitting. Funding is sought to democratize AI and advance its applications.

Mentals AI is a tool designed for creating and operating agents that feature loops, memory, and various tools, all through straightforward markdown syntax. This tool enables you to concentrate solely on the agent’s logic, eliminating the necessity to compose underlying code in Python or any other language. It redefines the foundational frameworks for future AI applications by allowing the creation of agents with recursive decision-making processes, integration of reasoning frameworks, and control flow expressed in natural language. Key concepts include instructions with prompts and references, working memory for context, short-term memory for storing intermediate results, and control flow from strings to algorithms. The tool provides a set of native tools for message output, user input, file handling, Python interpreter, Bash commands, and short-term memory. The roadmap includes features like a web UI, vector database tools, agent's experience, and tools for image generation and browsing. The idea behind Mentals AI originated from studies on psychoanalysis executive functions and aims to integrate 'System 1' (cognitive executor) with 'System 2' (central executive) to create more sophisticated agents.

LightLLM is a Python-based LLM (Large Language Model) inference and serving framework known for its lightweight design, scalability, and high-speed performance. It offers features like tri-process asynchronous collaboration, Nopad for efficient attention operations, dynamic batch scheduling, FlashAttention integration, tensor parallelism, Token Attention for zero memory waste, and Int8KV Cache. The tool supports various models like BLOOM, LLaMA, StarCoder, Qwen-7b, ChatGLM2-6b, Baichuan-7b, Baichuan2-7b, Baichuan2-13b, InternLM-7b, Yi-34b, Qwen-VL, Llava-7b, Mixtral, Stablelm, and MiniCPM. Users can deploy and query models using the provided server launch commands and interact with multimodal models like QWen-VL and Llava using specific queries and images.

This repository contains the training code of MobileLLM, a language model optimized for on-device use cases with fewer than a billion parameters. It integrates SwiGLU activation function, deep and thin architectures, embedding sharing, and grouped-query attention to achieve high-quality LLMs. MobileLLM-125M/350M shows significant accuracy improvements over previous models on zero-shot commonsense reasoning tasks. The design philosophy scales effectively to larger models, with state-of-the-art results for MobileLLM-600M/1B/1.5B.

torchchat is a codebase showcasing the ability to run large language models (LLMs) seamlessly. It allows running LLMs using Python in various environments such as desktop, server, iOS, and Android. The tool supports running models via PyTorch, chatting, generating text, running chat in the browser, and running models on desktop/server without Python. It also provides features like AOT Inductor for faster execution, running in C++ using the runner, and deploying and running on iOS and Android. The tool supports popular hardware and OS including Linux, Mac OS, Android, and iOS, with various data types and execution modes available.

PaperQA is a minimal package for question and answering from PDFs or text files, providing very good answers with in-text citations. It uses OpenAI Embeddings to embed and search documents, and includes a process of embedding docs, queries, searching for top passages, creating summaries, using an LLM to re-score and select relevant summaries, putting summaries into prompt, and generating answers. The tool can be used to answer specific questions related to scientific research by leveraging citations and relevant passages from documents.

hackingBuddyGPT is a framework for testing LLM-based agents for security testing. It aims to create common ground truth by creating common security testbeds and benchmarks, evaluating multiple LLMs and techniques against those, and publishing prototypes and findings as open-source/open-access reports. The initial focus is on evaluating the efficiency of LLMs for Linux privilege escalation attacks, but the framework is being expanded to evaluate the use of LLMs for web penetration-testing and web API testing. hackingBuddyGPT is released as open-source to level the playing field for blue teams against APTs that have access to more sophisticated resources.

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.

Looper query strings assistant

Getting ready to query agents or publishers? Upload your manuscript. I analyse your novel's writing style, themes and genre. I'll tell you how it's relevant to a modern audience, offer marketing insights and will even write you a draft synopsis and cover letter. I'll help you find relevant agents.

I conjure advanced Google search queries.

Enhances PubMed searches with MeSH and follow-up advice

The KQL Query Helper GPT is tailored specifically for assisting users with Kusto Query Language (KQL) queries. It leverages extensive knowledge from Azure Data Explorer documentation to aid users in understanding, reviewing, and creating new KQL queries based on their prompts.

Expert in brief, direct SQL queries for BigQuery, with casual professional tone.

Helps get map data from Open Street Map by generating Overpass Turbo queries. Ask me for mapping features like cafes, rivers or highways

Expert in Power Query and DAX for Power BI, offering in-depth guidance and insights

Create the most effective database or search engine queries using keywords, truncation, and Boolean operators!

Query BCorp company data. All data is publicly available. United Kingdom only (for now).

SQL query validator and educator, adaptable to user's format.

Supabase expert also supports query generation and Flutter code generation

I'm your guide for any query and information related to TikTok Ads. Let's build your new campaign together!

Answers in query language, adds Korean translation and phonetics for non-Korean queries.

Welcome to AIHelp.bot, your versatile assistant for any query. Whether it's a general knowledge question, a technical issue, or something more obscure, I'm here to help. Please type your question below, and I'll use my resources to find the best possible answer.

Knows the docs and can query official ordinal endpoints—Sat Numbers, Inscription IDs, and more.

Specializes in web searches for chat.openai.com using specific query format.

A sales enablement assistant for content creation and query resolution.

Amazon product shopping search, conveniently query products, get discounts and discounted products more quickly.

“Data Deep Dive”: This is an expert AI tool for Excel and Power BI. Get expert help with DAX, Power Query, VBA, data models, and visualizations. Ideal for all levels: from basic functions to advanced analytics.