Introduction
Turn your data into insights with natural language. GoPie is an open source platform for instant data analysis and API generation
GoPie is an open-source platform that transforms your datasets into blazing-fast, AI-ready databases with auto-generated APIs. Query your data using natural language, create stunning visualizations, and share insights effortlessly.
GoPie makes data analysis as easy as pie!
No SQL knowledge? No problem! Just ask questions in plain English and let GoPie handle the rest.
What is GoPie?
GoPie bridges the gap between technical and non-technical users by providing:
- Smart Data Import: Drag-and-drop files or connect to databases with automatic cleaning
- Natural Language Queries: Ask questions about data in plain English or any preferred language.
- Instant APIs: Every dataset automatically gets a REST API with documentation
- AI-Powered Insights: Leverage advanced language models to understand and analyze your data
- Self-Hosted Freedom: Keep full control of your data with Docker deployment
Key Features
Multi-Source Data Import
Import data from anywhere - CSV, Excel, Parquet, JSON files from locally or from Google Drive, One Drive or from URLs. Users can also import the data connecting to databases like Postgres, MySQL etc. GoPie automatically cleans and normalizes your data.
Optimize Datasets for AI
During upload, clean your data, include metadata for columns and descriptions, and follow best practices to create datasets primed for AI-driven queries and discovery. GoPie also enables exposing datasets to other AI applications using MCP servers for seamless integration.
Instant SQL Playground
Uploaded datasets turn into live database complete with a full-featured SQL playground and a natural-language querying. No database expertise needed.
Data Analysis over chat
Effortlessly analyze datasets & also generate visualizations using natural language in the chat interface. GoPie interprets your requests to produce clear, customizable visuals like trends, distributions, or comparisons, helping you uncover and communicate insights without any technical expertise.
Auto-Generated APIs
Every dataset becomes a fully-documented REST API with pagination, filtering, and versioning - no backend code required.
Who is GoPie For?
Non-Technical Data Analysts
Transform data into insights without SQL expertise. Perfect for business analysts, data journalists, and operations managers who need to explore datasets, generate visualizations, and cross-reference multiple sources using natural language.
App Builders & Developers
Turn any dataset into production-ready APIs instantly. Build internal tools, connect to low-code platforms like Retool or V0, and skip weeks of backend development. Deploy customer dashboards and data-driven applications in hours, not months.
AI & Innovation Teams
Prepare datasets for LLM consumption with proper metadata. Enable semantic search, expose data via MCP servers for AI integration, and connect to ChatGPT, Claude, or custom agents. Reduce time-to-insight from weeks to minutes.
Data Monetization Teams
Convert data assets into revenue streams. Create tiered API access for clients, sell anonymized benchmarks, or white-label GoPie as your data platform. Ideal for consultants and companies looking to productize their data.
Enterprise & Research Organizations
Self-host for complete control and compliance. Meet HIPAA/GDPR requirements, integrate with existing SSO systems, and keep sensitive data within your infrastructure. Perfect for universities, healthcare, and regulated industries.
Who is GoPie Not For?
GoPie may not be the right fit if you:
- Work exclusively with unstructured documents - GoPie is optimized for structured, tabular data (CSV, Excel, databases)
- Need real-time streaming analytics - Better suited for batch processing and exploratory analysis
- Only need basic spreadsheet functionality - May be overkill for simple Excel-like calculations
Architecture Overview
GoPie uses a modern microservices architecture:
- Frontend: Next.js 15 with React 19 for a performant UI
- Backend: Go server for high-performance data operations
- AI Engine: Multi-agent AI system using LangGraph for orchestrating complex workflows
- Databases: PostgreSQL for metadata, DuckDB for analytics
- Vector Search: Qdrant for semantic understanding of your data
Getting Started
Choose Your Path
- Quick Start - Get running in 5 minutes with Docker
- Installation Guide - Detailed setup instructions
- First Dataset - Upload and query your first dataset
Explore Features
- User Guide - Learn all GoPie features
- Tutorials - Real-world examples and use cases
- API Reference - Technical documentation
Join the Community
- GitHub - Star the repo and contribute
- Discord - Get help and share experiences
- Contributing - Help make GoPie better