Infrastructure

PostgreSQL

Relational database with pgvector 0.8 for vector similarity search, hybrid search (keyword + vector), HNSW indexing, and full ACID compliance.

self-hosted-or-managed · $0-$25/mo

Visit website

Features

  • pgvector 0.8 with HNSW and IVFFlat indexes
  • Hybrid search combining keyword BM25 + vector similarity
  • 6 distance functions (L2, cosine, inner product, L1, Hamming, Jaccard)
  • Full ACID compliance with JOINs and point-in-time recovery
  • Managed hosting via Supabase, Railway, Neon, and AWS RDS

Best use cases

Best use cases

Data Analyst Agent

Data teams spend 60% of their time on recurring reports and ad-hoc queries rather than strategic analysis. Manual dashboard compilation introduces delays and human error, while stakeholders wait days for insights that should be available in minutes.

Open Guide

Compatible tools

OpenAI

GPT-5.2 and o-series reasoning models with the Responses API, AgentKit, and built-in tools for web search, code execution, and computer use.

usage-based

Open Tool

Railway

Developer-first app platform with usage-based compute pricing, one-click database provisioning (Postgres with pgvector, Redis), and transparent billing.

usage-based

Open Tool

Redis

In-memory data store with Vector Sets (Redis 8 preview) for native vector search, semantic caching, JSON document storage, and session management for AI agents.

open-source-or-cloud

Open Tool

Supabase

Postgres backend with built-in pgvector for vector search, hybrid search (BM25 + vector), auth, real-time subscriptions, edge functions, and row-level security.

freemium

Open Tool

Vercel

Frontend and serverless hosting with AI SDK 6 (Agent abstraction, MCP support), AI Gateway across major LLM providers, and edge functions.

usage-based

Open Tool