{"repo":"DataZooDE/flapi","free":true,"listed":false,"github":"https://github.com/DataZooDE/flapi","clone":"git clone https://github.com/DataZooDE/flapi.git","description":"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","language":"C++","stars":73,"topics":["api","cpp","duckdb","duckdb-extension","openapi3","rest","mcp","mcp-server","vscode-extension"],"license":null,"category":"mcp-servers","readme_excerpt":"flAPI: Instant SQL based APIs flAPI is a powerful service that automatically generates read-only APIs for datasets by utilizing SQL templates. Built on top of DuckDB and leveraging its SQL engine and extension ecosystem, flAPI offers a seamless way to connect to various data sources and expose them as RESTful APIs. ⚡ Features - Automatic API Generation : Create APIs for your datasets without coding - MCP (Model Context Protocol) Support : Declarative creation of AI tools alongside REST endpoints — with per-tool RBAC ( allowed-roles ), shadow/dry-run ( dryRun: true ), response shaping ( max-rows / redact-columns / sample ), per-tool rate limit , and a tool-description hygiene scanner for prompt-injection attempts - Multiple Data Sources : Connect to BigQuery, SAP ERP & BW (via ERPL), Parquet, Iceberg, Postgres, MySQL, and more - SQL Templates : Mustache-like syntax. Typed {{ params.X }} references on int / double / boolean / date / time / uuid / enum / email / string fields are bound as DuckDB prepared statements — SQL injection is structurally impossible for those sites - Caching : DuckLake-backed cache with full refresh and incremental sync - Production security : PBKDF2-SHA256 password hashing, config-driven CORS allowlist, per-user rate limiting, JSONL request audit log, TLS termination, startup config auditor — all opt-in via single-line YAML so flapii project init demos stay simple - Easy deployment : Deploy flAPI with a single binary file - Self-packaging : Fold an enti","default_branch":null,"files":null,"tree":[],"storefront":"/r/DataZooDE","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DataZooDE/flapi/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}