VerbaGPT

VerbaGPT: Talk to Your Data with Privacy

What is VerbaGPT? VerbaGPT is an open-source tool that makes data analysis accessible by allowing you to interact with your data using natural language. It leverages large language models (LLMs) to understand your queries and provide insightful answers from your SQL data, CSV files, or personal notes.

Key Features:

• Natural Language Data Analysis: Ask questions about your data in plain English and receive answers powered by LLMs.
• Text-to-Python Power: Goes beyond simple SQL queries by enabling complex statistical and visualization capabilities using Python.
• Data Privacy: Runs locally on your hardware, ensuring your data remains private. The LLM only receives the schema and information you explicitly provide.
• Designed for Simplicity: Focuses on ease of use, hiding the complexities of generative AI in the background.
• Versatile Data Connectivity:
  • Upload data in CSV/TXT format.
  • Connect to MSSQL, MySQL, and PostgreSQL databases locally or remotely.
• Model Flexibility:
  • Offers a curated list of models, including free-to-use options.
  • Option to operate completely offline (experimental).
  • Supports toggling between different LLMs (OpenRouter, OpenAI, etc.).
• Advanced Capabilities:
  • Advanced data visualizations and modeling.
  • 'Retry' button to automatically recover from code execution errors.
  • 'Analyze' button for code and results commentary.
  • Ability to block harmful SQL commands.
  • Manage data descriptions for multiple databases.
  • Train model with successful question-SQL pairs.
  • Flagging unsuccessful generations

How does VerbaGPT work?

VerbaGPT functions as a bridge between you and your data. You provide the data (SQL database, CSV, etc.) and ask questions in natural language. The tool then uses an LLM to translate your question into code (primarily Python, including SQL queries when needed). The code is executed locally, and the results are presented back to you in a clear and understandable format.

How to use VerbaGPT?

1. Download and Install: Download VerbaGPT from the official website (link not provided in text, search for it). It's an open-source program, so you'll likely need to follow installation instructions specific to your operating system.
2. Connect to Your Data: Upload your data in CSV/TXT format or connect to your SQL database (MSSQL, MySQL, PostgreSQL). Provide the necessary credentials for database connections.
3. Ask Questions: Start asking questions about your data in natural language. For example, "What are the top 5 products sold last month?" or "Show me a chart of sales by region."
4. Analyze Results: VerbaGPT will generate the appropriate code, execute it, and display the results. Use the 'Analyze' button to get commentary on the code and results.

Why is VerbaGPT important?

VerbaGPT democratizes data analysis. It removes the barrier of needing to know complex coding languages like SQL or Python. Subject-matter experts can directly interact with their data and gain insights without relying on data scientists or programmers. The emphasis on local processing and data privacy is crucial in today's data-sensitive environment.

Who is VerbaGPT for?

VerbaGPT is ideal for:

• Business Analysts: Quickly analyze data and generate reports without coding.
• Researchers: Explore datasets and uncover patterns more efficiently.
• Data Scientists: Prototype data analysis workflows and explore data interactively.
• Anyone who wants to understand their data better: VerbaGPT makes data analysis accessible to everyone, regardless of their technical skills.

Experimental Software

Like all LLM-enabled software, VerbaGPT is experimental software exploring potential use-cases. Please treat it as such and be careful relying on the output from any LLM-based product. We think that one day LLMs will be good enough to remove coding as a barrier between subject-matter experts and the vast stores of data that could help them in their work. Happy exploring!

VerbaGPT is free for personal use. Download it and start exploring your data today!