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…
- Transport
- Not stated
- Package
- —
- Registry id
- —
No install snippet on purpose. A working MCP config is a command, its arguments and an environment block — the last two are where API keys live, so this catalogue never stores them and cannot publish them. Follow the link above for the authors' own instructions.
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.