Skip to main content

Marketplace Examples

Production-ready Air Pipe configurations you can deploy in one click. Every example below is a live marketplace pack — browse and install them at app.airpipe.io/marketplace.

AI & Agents​

  • Gemini AI — Query Google's Gemini models over a simple HTTP API. Three routes: the full generateContent payload, just the answer text, or an instruction-prefixed answer. The API key and model are managed variables, so you can swap models without redeploying; the prompt is JSON-escaped before it hits the Gemini API.
  • LLM Gateway — A configurable LLM completion and content-moderation endpoint. System prompt, model, and API key live in managed variables — swap providers or update prompts without touching the config or redeploying. Exposes POST /ai/complete (chat completion) and POST /ai/moderate (OpenAI moderation, free) with request validation and per-model metrics.
  • MCP Postgres Starter — Turn your Postgres data into secure MCP tools any AI client (Claude Desktop, Claude Code, Cursor) can call. Two-tier auth: one shared token for yourself, or per-user tenant-scoped tokens for your customers - minted via an HS256 exchange or verified directly against your OIDC provider's JWKS (Auth0, Clerk, Cognito). Every tool reuses the same in-config token checks as a normal Air Pipe route.
  • MongoDB Atlas Vector Search RAG — Retrieval-Augmented Generation chatbot backed by MongoDB Atlas Vector Search. Ingest your own documents, embed them with OpenAI, and answer questions with $vectorSearch — your documents and their embeddings live in one database, no separate vector store. The Atlas-native companion to the pgvector AI RAG Chatbot.
  • RAG Chatbot — Retrieval-Augmented Generation chatbot backed by Postgres + pgvector. Ingest your own documents, store OpenAI embeddings alongside them, and answer questions using only your data — no third-party vector DB, no proprietary cloud, nothing leaves your infrastructure. Includes seed, ingest, chat, history, and delete endpoints.

Backend & APIs​

  • Air Pipe Fundamentals — A reference config covering every core Air Pipe concept - the five input sources, interpolation forms, assertions, run conditions, transforms, and metrics - against public APIs (no database or managed variables needed). Not a production pack: use it as a learning reference and to seed a RAG chatbot with authoritative Air Pipe syntax.
  • FCM Push Notifications — Send Firebase Cloud Messaging (FCM) push notifications straight from your database — register device tokens, send to one device, or fan out to every device a user owns. No app server, no Firebase Admin SDK. A drop-in replacement for a Supabase + FCM setup.
  • MongoDB Atlas Backend / REST API — A production-shaped REST API over a MongoDB Atlas database — CRUD for users, posts, and categories, optional JWT validation, and a set of aggregation-pipeline analytics endpoints. No ORM, no Mongoose, no backend boilerplate: point AirPipe at your Atlas connection string and you have an API.

Already on the Next.js + MongoDB stack? This is the missing backend. Deploy it over your existing Atlas cluster and start making requests in under 10 minutes.

  • Multi-Tenant SaaS Starter — A production-shaped multi-tenant backend over Postgres: API-key authentication (sha256-hashed, generated server-side, revocable), strict per-tenant data isolation, plan-based limits, and usage metering. Every request resolves its API key to exactly one tenant and every query is scoped to it — cross-tenant access is structurally impossible. The 'Air Pipe is a real backend, not a workflow tool' pack.
  • MySQL REST API Starter — A production-shaped CRUD API over MySQL — users, posts, and comments, with optional JWT validation. Works with MySQL 8.x, MariaDB 10.5+, and PlanetScale. No ORM, no boilerplate: point Air Pipe at your MySQL connection string and you have an API.
  • REST API Starter — A production-shaped CRUD API over Postgres with three resource types (users, posts, comments) and optional JWT validation. No external services required — just a Postgres database. Deploy and start making requests in under 10 minutes.
  • Send Email (SMTP and Resend) — Two ways to send transactional email from one Air Pipe route, with an identical { to, subject, html } body: the native email action over SMTP (STARTTLS, works with any mail server) or the Resend HTTP API. Pick the file for your provider; user values are JSON-escaped so quotes and newlines can't break the payload.
  • SQLite REST API Starter — A production-shaped CRUD API over SQLite — users, posts, and comments, with optional JWT validation. Zero setup: no database server to provision, just a portable single-file .db. The zero-config, file-based member of the REST API Starter family. Self-hosted only — the SQLite driver runs in-process, so this pack is for your own AirPipe instance (local-first, edge, prototypes).

Data & Analytics​

  • Daily Database Digest Email — Query your database, format a summary email, and send it via Resend. Ships with a sample app_events table so you can try it immediately. Swap the query for any SQL that returns numbers your team cares about — signups, revenue, errors, API calls.
  • Event Tracking — Lightweight product analytics backend. Track any named event with arbitrary properties, then query counts and user histories. No third-party analytics service required — your data stays in your database.

Engineering & DevOps​

  • Flow Control — Flow-control recipes for Air Pipe pipelines: throttle with the delay action, retry with exponential backoff, branch with run_on_assertion, try/catch/finally recovery, and at_least quorum. Every endpoint is self-contained — no external services, databases, or managed variables required.
  • GitHub Webhooks → Discord — Forwards GitHub events (push, pull request, issues) to a Discord channel as formatted embeds. No database required — it's a pure HTTP passthrough. Set up in under 5 minutes with two free accounts.
  • Observability Showcase — Deploy this config and three things appear immediately with zero extra work; Prometheus Metrics, Open Telemetry Tracing, OpenAPI Spec documentation. Every request becomes a trace you can inspect end-to-end: method, path, status code, latency, and which actions ran inside it. No annotations beyond the config. No code. No separate instrumentation setup.

Security & Compliance​

  • Audit Log + Compliance Reporting — Append-only audit log and compliance reporting API. Record every significant action in your system — logins, data access, mutations, exports, config changes — search them flexibly, generate compliance summaries, and manage retention. No extra services needed: it's all Postgres.
  • GDPR Data Export + Deletion — Two endpoints to satisfy GDPR Article 15 (right of access) and Article 17 (right to erasure). Every request is logged to an audit table. Data is kept on your own infrastructure — nothing leaves your database.
  • JWT Verification Starter — Verify JWTs three ways - against a provider's JWKS (Auth0, Clerk, Cognito, Firebase), a static PEM public key, or an HS256 shared secret - then protect a real per-user Postgres resource scoped to the token's sub claim. Reference endpoints for every is_valid_jwt mode plus a working, owner-scoped notes API and a one-call multi:true migration.
  • Network Firewall & Access Control — An API-layer network firewall — IP allow/deny lists (CIDR + IPv6), proxy-aware client resolution that defeats X-Forwarded-For spoofing, per-IP rate limiting, GeoIP/ASN blocking, monitor mode, and custom deny responses — declared per route. No database required.

Operations​

  • Durable API Polling — Poll an API on a schedule and process only new items, retrying only the items that fail — never the whole batch and never silently dropping a failure. Durable id-based dedupe via the state feature plus lookup_partition per-item retry. Includes a self-contained demo and a production poller template.
  • Feature Flags — Postgres-backed feature flag API. Create, toggle, and check flags from any service.

Sales & CRM​

  • Lead Capture — Capture leads from any form, landing page, or webhook. Every submission is validated, stored in Postgres, and fires an instant Slack notification. Your data stays on your infrastructure.

Customer Support​

  • Twilio SMS Bot — A Twilio SMS bot served straight from your database. Receives inbound SMS via a Twilio webhook, replies instantly with TwiML, routes keyword commands to canned replies, handles STOP/START opt-out, and logs every message. No app server.

Finance & Commerce​

  • Stripe Webhooks → DB → Slack — Receives Stripe webhook events, verifies the signature, stores every event in Postgres with idempotency, and posts a Slack notification. One endpoint handles all event types.

Utilities​

  • Webhook Logger / Inspector — A zero-dependency webhook capture tool. Point any webhook sender at /webhooks/log and the full request — body, headers, and query params — is stored in your Postgres database. Replay stored events to your local dev server without re-triggering the original source.

Useful for debugging Stripe, GitHub, Shopify, or any other webhook-based integration. Captures headers like X-Stripe-Signature, X-GitHub-Event, and X-Hub-Signature-256 alongside the body so you have everything needed to replay or verify the original request.