Flapi

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 f…

LLM Mart 2 views 53 listing impressions

flAPI is an open-source SQL-to-API framework that turns SQL queries into production-ready REST endpoints and MCP tools. It achieves sub-50 ms response times by serving requests from a local DuckDB snapshot. It integrates with BigQuery, Snowflake, Postgres, Parquet, SAP ERP, SAP BW, ODBC, Google Sheets, Power BI, and vector search.

The software ships as a single statically-linked binary distributed via PyPI and Docker. SQL injection is prevented by binding all parameters via DuckDB prepared statements. It offers pluggable authentication including Basic, JWT, Bearer, OIDC, and AWS Secrets Manager.

flAPI is free to run internally at any scale under the Business Source License.

Summary drafted from the project's own website. Every sentence is backed by text on that page and was reviewed before publishing.

Related servers

Read and write RAGE Package Format archives

23 views

See how ChatGPT, Claude, Gemini and Perplexity read any website. Scored out of 100.

19 views

MCP server for Geargrafx PC Engine / TurboGrafx-16 emulator

19 views

Read-only on-chain intel for AI agents on Base: balances, tokens, gas, tx status. No API keys.

15 views