AgentIndex icon
AgentIndex
ToolsCategoriesTrendingNewCompare
Submit Tool
Home/
Observability/
flapi
flapi logo

flapi

Active·★ 71·Apache-2.0·Updated 2026-05-25
★ Trending★ API Integration★ Data Processing

API Framework heavily relying on the power of DuckDB and DuckDB extensions. Ready to build performant and cost-efficient APIs on top of BigQuery or Snowflake for AI Agents and Data Apps

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
$ Install
$ docker pull ghcr.io/datazoode/flapi:latest && docker run -it --rm -p 8080:8080 -p 8081:8081 -v $(pwd)/examples/:/config ghcr.io/datazoode/flapi -c /config/flapi.yaml
↗ Visit site★ GitHub
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

GitHub MCP Server logo
GitHub MCP Server★ 30.3k
GitHub's official MCP Server. Allows AI agents to interact directly with your GitHub repositories (read files, search code, issues).
vs →
genai-toolbox logo
genai-toolbox★ 15.4k
MCP Toolbox for Databases is an open source MCP server for databases.
vs →
mindsdb logo
mindsdb★ 39.2k
Federated Query Engine for AI - The only MCP Server you'll ever need
vs →
n8n-mcp logo
n8n-mcp★ 21.4k
A MCP for Claude Desktop / Claude Code / Windsurf / Cursor to build n8n workflows for you
vs →
gemini-mcp-tool logo
gemini-mcp-tool★ 2.2k
MCP server that enables AI assistants to interact with Google Gemini CLI, leveraging Gemini's massive token window for large file analysis and codebase understanding
vs →
grafbase logo
grafbase★ 1.2k
The Grafbase GraphQL Federation Gateway
vs →
python-utcp logo
python-utcp★ 644
Official python implementation of UTCP. UTCP is an open standard that lets AI agents call any API directly, without extra middleware.
vs →
browser-tools-mcp logo
browser-tools-mcp★ 7.2k
Monitor browser logs directly from Cursor and other MCP compatible IDEs.
vs →
See all alternatives →

Related searches

flapi AlternativesBest Observability Tools 2026Open Source Observabilityflapi Tutorialflapi Vs CompetitorsAPI GenerationSQL TemplatesData Integration

Comments

Log in to leave a comment
  • D
    Drew WhiteMay 23, 2026

    The ability to read various data sources through DuckDB extensions is genuinely flexible

  • R
    Riley HarrisMay 19, 2026

    Used for building data APIs that aggregate from multiple sources without ETL

  • A
    Avery PatelMar 10, 2026

    DuckDB-powered API framework with extension support is a powerful combination

  • R
    Rowan MartinezMar 5, 2026

    Fast and lightweight compared to traditional API frameworks for analytics use cases

On this page
01Features02Compatibility03Quick start04Use cases05Alternatives
Stats
GitHub Stars★ 71
Last commit5d ago
StatusActive
LicenseApache-2.0
CategoryObservability
Trend (30d)
+2.8↑ 0.7%
Links
Documentation↗Discussion↗Issues↗Releases↗

Deploy on DigitalOcean — Get $200 Free Credit

Ad
© 2026 AgentIndex.app|Built by a 10-year iOS Developer.
QYSGitHubBuy me a coffee ☕

Browse by Category

Code AssistantWorkflow AutomationRAG / Knowledge BaseMulti-AgentBrowser AutomationLLM InfraDev ToolingObservability

Not affiliated with Anthropic, OpenAI or Microsoft.