flapi
Active·★ 74·Apache-2.0·Updated 2026-10-04
flAPI is a powerful service that automatically generates read-only RESTful APIs for various datasets using SQL templates, leveraging DuckDB's engine. It simplifies data exposure and supports advanced features like AI tool integration via the Model Context Protocol (MCP).
#API Generation#SQL Templates#Data Integration#DuckDB#RESTful API#Caching#AI Tools#Microservices
01
Features
01Automatic API Generation: Create APIs for your datasets without coding.
02Multiple Data Sources: Connect to BigQuery, SAP ERP & BW, Parquet, Iceberg, Postgres, MySQL, and more.
03SQL Templates: Use Mustache-like syntax for dynamic queries.
04Caching: DuckLake-backed cache with full refresh and incremental sync.
05MCP (Model Context Protocol) Support: Declarative creation of AI tools alongside REST endpoints.
02
Compatibility
DuckDB
Database Engine
Verified via docs
Docker
Deployment
Verified via docs
BigQuery
Data Source
Verified via docs
Postgres
Data Source
Verified via docs
MySQL
Data Source
Verified via docs
Parquet
Data Format
Verified via docs
03
Quick start
1
$ docker pull ghcr.io/datazoode/flapi:latest
2
$ docker run -it --rm -p 8080:8080 -p 8081:8081 -v $(pwd)/examples/:/config ghcr.io/datazoode/flapi -c /config/flapi.yaml
04
Use cases
↳Exposing internal datasets as secure read-only APIs for applications or dashboards.
↳Creating a unified API layer over diverse data sources like BigQuery, Postgres, and local Parquet files.
↳Building AI-driven tools that require declarative access to structured data via the Model Context Protocol.
↳Rapid prototyping and deployment of data-driven microservices with built-in security and caching.
05
Alternatives
OpenStudy★ 76
Self-hostable study dashboard with a built-in MCP server so Claude can read, write, and teach from your courses, lectures, and deadlines — Making better use of your Claude/ChatGPT subscription
study-dashboard★ 76
Self-hostable study dashboard with an MCP connector so Claude (claude.ai, Claude Desktop, Claude Code or any Claude surface) can read and write your coursework.
Comments
Log in to leave a comment
No comments yet. Be the first!