How it Works
flAPI simplifies the process of creating data APIs into three straightforward steps. This effectively decouples high-throughput API consumers (like AI agents or web services) from traditional backend data systems, resulting in significantly improved performance and lower costs.
Connect Your Data
Point flAPI to your data sources—BigQuery, Snowflake, Parquet files, or PostgreSQL. Use the full power of DuckDB's extension ecosystem.
Define APIs with SQL
Write standard SQL queries and define endpoints using simple YAML files. Use Mustache syntax for dynamic, parameterized queries.
Access Instantly
Run the flAPI server and immediately access your data through secure, documented REST APIs—plus MCP tools for AI agents.
Packed with Power
Everything you need to build blazing-fast data APIs,
from prototype to production.
Instant API Generation
Go from SQL query to REST API in minutes. Automatic OpenAPI documentation, validation, and error handling included.
Local-First Development
Lightweight single binary that starts in milliseconds. Develop locally with the same software you ship to production.
High-Performance Serving Layer
DuckDB-powered caching absorbs high-frequency queries, protecting your backend and slashing costs by 90%.
Built for AI-Native Enterprise
Model Context Protocol (MCP) support enables AI agents to access your data securely and efficiently.
Built for Any Use Case
Internal Analytics API
Problem: BI dashboards are slow and expensive, hitting the data warehouse for every filter change.
Solution: flAPI serves pre-aggregated data from its cache, enabling instant, free dashboards.
Learn how →Customer Data Endpoints
Problem: Customer support needs access to real-time data from SAP, but direct access is slow and risky.
Solution: flAPI provides a secure, cached API layer, giving support fast access to the data they need.
Learn how →Real-Time Reporting
Problem: AI agents need to query production databases for real-time reports, risking performance.
Solution: flAPI offers a safe, rate-limited, and cached endpoint, protecting your production database.
Learn how →Built for Everyone, Supported for Enterprises
Enterprise Support & Consulting
Scale with confidence. Get expert help when you need it most.
What's Included:
- ✓Architecture & Design
Expert consultation on data modeling, caching strategies, and API design
- ✓Implementation Support
Hands-on help deploying flAPI for complex enterprise use cases
- ✓Training & Enablement
Custom workshops and training for your development team
- ✓Priority Support
Direct access to engineering team with guaranteed response SLAs
Commercial Licensing for Product Builders
Building a product on flAPI? Let's partner on your success.
Our Approach:
- ✓Fair Share Model
We believe in mutual success—get the licensing terms that work for your business
- ✓Flexible Licensing
Revenue share, per-seat, or custom arrangements—we adapt to your model
- ✓Partnership Benefits
Priority feature requests, dedicated support, and go-to-market collaboration
- ✓Legal Clarity
Clear licensing terms under BSL, with straightforward commercial agreements
Questions about licensing? If you're using flAPI internally (even at enterprise scale), building open source projects, or creating free tools—you don't need a commercial license. Only companies building commercial products on top of flAPI need licensing terms.