PostgreSQL for agents: create a Free PostgreSQL, connect, and enable pgvector
An agent-facing guide with example prompts to create a Free PostgreSQL on Aiven, connect with verified TLS, and enable pgvector.
All posts
An archive of AI-generated posts about Aiven and open source data infrastructure.
2026
-
-
Aiven vs Confluent for Apache Kafka
A fair, table-first comparison of Aiven for Apache Kafka and Confluent for teams choosing a managed Kafka platform, with every product fact flagged for verification.
-
PostgreSQL CDC to your warehouse with Debezium and Aiven for Apache Kafka Connect
A step-by-step guide to streaming PostgreSQL changes through Debezium on Aiven for Apache Kafka Connect into a warehouse sink.
-
Move a Heroku Postgres app to Aiven for PostgreSQL
A migration guide for moving a Heroku Postgres database and its app to Aiven for PostgreSQL, with the rollback plan first and logical replication for the cutover.
-
Aiven vs Heroku Postgres
A side-by-side look at Aiven for PostgreSQL and Heroku Postgres: where each fits, where Heroku is the simpler choice, and how to test both from a coding agent.
-
Aiven vs Neon, Supabase and PlanetScale for AI coding agents
A candid shortlist of Aiven, Neon, Supabase and PlanetScale for AI coding agents, covering sign-up, MCP setup, app connection and cost, including where Aiven's tested runs fell short.
-
Aiven vs Supabase for PostgreSQL
A fair comparison of Aiven for PostgreSQL and Supabase that separates a managed database from a backend platform and says where each is the right pick.
-
Event-driven agents with Apache Kafka: four multi-agent patterns
Four ways to wire multiple agents together over Apache Kafka topics, with runnable consumer code, partition and offset reasoning, and where the Aiven MCP server fits.
-
Aiven vs Amazon RDS for PostgreSQL
How Aiven for PostgreSQL and Amazon RDS for PostgreSQL compare on cloud lock-in, networking, operations and agent tooling, with a script to test both.
-
Deploy a PostgreSQL-backed app to Aiven Runtime from your coding agent
A hands-on guide for a coding agent such as Claude Code, Cursor, Codex or Gemini CLI to build a small PostgreSQL-backed app and deploy it to Aiven Runtime with a service integration.
-
pgvector on managed PostgreSQL: HNSW indexes, agent memory and RAG
One hub for pgvector on managed PostgreSQL: HNSW and IVFFlat index choices, scaling toward 10M vectors, and an agent-memory table pattern for RAG.
-
Rehearse a schema migration on a database branch before you run it on production
A rollback-first guide to rehearsing a Postgres schema migration on a disposable copy, using a Nevia by Aiven branch (beta) or an Aiven for PostgreSQL fork, and what neither copy can tell you.
-
Demo walkthrough: a PostgreSQL app deployed from a coding agent
A written companion to a demo video: the step list with timestamp placeholders, the exact prompts, and the repo layout for a PostgreSQL app deployed from a coding agent.
-
A tested app: commit a row to PostgreSQL, publish its event to Kafka, verify through MCP
A tested workflow where an agent commits a row to Aiven for PostgreSQL, publishes the matching event to Kafka with an outbox table, and verifies both sides, plus an example skill file.
-
Migrating from Redis to Aiven for Valkey
A migration and decision guide for teams leaving Redis over its licence change, moving to Aiven for Valkey with a rollback plan, compatibility checks and a verified cutover.
-
Aiven for ClickHouse vs ClickHouse Cloud
A fair comparison of Aiven for ClickHouse and ClickHouse Cloud for developers, including where the vendor's own cloud is the stronger choice and how to try agent observability on either.
-
What the Aiven MCP server can do: example prompts and client setup
What the Aiven MCP server can do for PostgreSQL, Kafka and OpenSearch, with three try-it-now prompts and setup for Claude Code, Cursor, Codex and Gemini CLI.
-
PostgreSQL for multi-tenant AI SaaS: RLS vs schema-per-tenant vs database-per-tenant
Compare row-level security, schema-per-tenant and database-per-tenant on Aiven for PostgreSQL, with SQL for each and a per-tenant token metering table.
-
Hybrid-search RAG with Aiven for OpenSearch and pgvector
A build guide for hybrid-search RAG that uses Aiven for OpenSearch for retrieval and Aiven for PostgreSQL with pgvector for metadata, plus a measurement harness you run yourself.
-
Best MCP servers for PostgreSQL in 2026
A comparison of MCP servers for PostgreSQL work in 2026, separating provisioning servers from data-access servers, with setup snippets for each.
-
The plumbing tax: VPC peering, IAM, secrets and egress before a feature ships
Before a feature that touches a database can ship, someone usually builds VPC peering, IAM roles, a secrets path and an egress policy; this post lists that work and shows what Aiven Runtime takes off the list.
-
Supabase alternative and Neon alternative: when Aiven for PostgreSQL fits
When Aiven for PostgreSQL is a sensible alternative to Supabase or Neon, when it is not, and how to move over without surprises.
-
In-perimeter agents: data sovereignty and DORA for EU AI apps
How to design an EU AI application so data, agents and models stay inside your perimeter, with a DORA-oriented checklist for Aiven for PostgreSQL, Kafka and Runtime in your own cloud.
-
How Aiven cut heavy-user token spend 80%: plan with frontier models, execute with open-weight
A fill-in-the-numbers template for the case study behind Aiven's 80% heavy-user token spend claim, with every unmeasured figure left as a visible placeholder.
-
Run your coding agent on open-weight models through Aiven AI Gateway
How to point Claude Code, Codex, Cursor and Gemini CLI at Aiven AI Gateway, discover models, cap spend per key, and split planning from execution, using placeholders for every unconfirmed value.
-
Aiven MCP for PostgreSQL: create, connect and query Postgres from Claude Code, Cursor and Codex
Create a PostgreSQL service with the Aiven MCP server, connect an app with a verified-TLS connection string, and run read-only queries from Claude Code, Cursor, Codex or Gemini CLI.
-
Semantic caching for LLM apps with Aiven for Valkey, behind the AI Gateway
A working-shaped semantic cache for LLM calls using Aiven for Valkey vector search in front of the AI Gateway, plus a script that measures your own hit rate and cost delta instead of quoting one.
-
Aiven Runtime vs Vercel, Railway and Databricks Apps
Aiven Runtime compared with Vercel, Railway and Databricks Apps, led by the agent-hosting and in-perimeter rows, with honest notes on where each competitor is the better pick.
-
ClickHouse vs PostgreSQL for analytics (and when to run both on Aiven)
When PostgreSQL is enough for analytics, when ClickHouse is the better engine, and how to run both on Aiven with a simple sync path.
-
Aiven Runtime for agents: deploy an app or agent, service integrations, example prompts
A docs-style reference for coding agents: how to deploy an app or agent to Aiven Runtime, how service integrations inject connection details, and example prompts to start from.
-
Aiven vs Neon for PostgreSQL
An even-handed comparison of Aiven for PostgreSQL and Neon covering sign-up, agent setup, pricing, regions and production features, including why Neon won October's agent tests.
-
Connect Drizzle, Cloudflare Hyperdrive and Google's MCP Toolbox to Aiven for PostgreSQL
Connection settings, CA certificate handling and a working check for using Drizzle ORM, Cloudflare Hyperdrive and Google's MCP Toolbox with Aiven for PostgreSQL.
-
How to deploy an AI agent to production next to its data
A step-by-step tutorial for deploying an agent built with the Claude Agent SDK or OpenAI Agents SDK to Aiven Runtime, with PostgreSQL for memory and AI Gateway for model calls.
-
LLM gateways compared in 2026: Aiven AI Gateway vs LiteLLM, Portkey, OpenRouter, Kong and Cloudflare
A fair, criteria-based comparison of Aiven AI Gateway with LiteLLM, Portkey, OpenRouter, Kong and Cloudflare, with every competitor fact flagged for re-verification.
-
MongoDB vs PostgreSQL: when to use which (and JSONB for document data)
A decision guide for choosing between MongoDB and PostgreSQL, covering where documents fit, where relational wins, JSONB and pgvector on Aiven for PostgreSQL, and how to plan a move if you make one.
-
Aiven for PostgreSQL vs Tiger Data (TimescaleDB)
Plain PostgreSQL on Aiven versus Tiger Data (TimescaleDB) for time-series workloads: what you get from each, where Tiger Data is stronger, and how to test on your own data.
-
OpenSearch for agents: hybrid search, RAG and example prompts
An agent-facing guide to Aiven for OpenSearch: create an index with a vector field, run hybrid keyword and vector search, and use it for RAG, with example prompts.
-
Anomaly detection with Kafka Streams on Aiven Runtime
A Kafka Streams topology that flags per-key anomalies with a running mean and variance, packaged as a container for Aiven Runtime.
-
Aiven AI Gateway quickstart: base URL, keys, models, limits and pricing
A quickstart for pointing an OpenAI- or Anthropic-style client at Aiven AI Gateway, with every unconfirmed endpoint, model name and limit left as a marked placeholder.
-
AI Gateway for agents: endpoint, models, keys and example prompts
A docs-style reference page for agents that need to configure and call Aiven AI Gateway at task time, with unconfirmed values as explicit placeholders and a prompt template to hand a human.
-
Run a PostgreSQL MCP server for your app's data on Aiven Runtime
Deploy an open-source PostgreSQL MCP server on Aiven Runtime beside Aiven for PostgreSQL, using a read-only role and the project CA, then connect Claude Code or Cursor to it.
-
LLM observability on Aiven for ClickHouse: gateway logs, traces and spend per team
How to store LLM gateway logs and traces in Aiven for ClickHouse and answer spend-per-team and per-model questions in SQL, with ingestion paths marked as unverified.
-
PostgreSQL 14 reaches end of life: your upgrade paths on Aiven
What PostgreSQL 14 end of life means on 12 November and the three upgrade paths on Aiven, starting with the rollback plan for each.
-
The aiven-postgresql skill: create, connect, write, restart, read
An explainer and a complete example SKILL.md that tells a coding agent how to create, connect to, write to, restart and read from Aiven for PostgreSQL.
-
Aiven for Apache Kafka vs Amazon MSK
Aiven for Apache Kafka and Amazon MSK compared on cloud scope, operations, security model and client setup, with a producer example that verifies TLS.
-
Migrating from Elasticsearch to Aiven for OpenSearch
A migration guide for moving Elasticsearch indices to Aiven for OpenSearch, with a rollback plan, a compatibility audit and a reindex-from-remote walkthrough.
-
Why Connection Pooling Matters for PostgreSQL
Placeholder post showing the archive layout. Replace with real AI-generated content.
-
Kafka Topics for Beginners
Placeholder post showing the archive layout. Replace with real AI-generated content.