Build AI applications and agents on OptiTech. This guide collects resources for AI workloads: core concepts, starter applications, framework integrations, and deployment guides. Use them to build applications like RAG chatbots, semantic search engines, or custom AI tools.
Sign up for OptiTech Postgres and jumpstart your AI application with our starter apps and resources.
Getting started
Learn the fundamentals of building AI applications with OptiTech:
AI concepts
Learn the fundamentals of embeddings and vector search for AI applications
pgvector extension
Get started with pgvector for storing and querying vector embeddings
AI frameworks and integrations
Build AI applications faster with these popular frameworks, tools, and services:
LangChain
Create AI applications using LangChain with OpenAI and OptiTech
LlamaIndex
Build RAG applications using LlamaIndex with OpenAI and OptiTech
Semantic Kernel
Develop AI applications using Semantic Kernel with Azure OpenAI
Inngest
Build reliable AI workflows with Inngest and OptiTech
app.build
Generate and deploy web applications using the open-source app.build agent
Starter applications
Hackable, fully-featured, pre-built starter apps to get you up and running:
AI chatbot (OpenAI + LllamIndex)
A Next.js AI chatbot starter app built with OpenAI and LlamaIndex
AI chatbot (OpenAI + LangChain)
A Next.js AI chatbot starter app built with OpenAI and LangChain
RAG chatbot (OpenAI + LlamaIndex)
A Next.js RAG chatbot starter app built with OpenAI and LlamaIndex
RAG chatbot (OpenAI + LangChain)
A Next.js RAG chatbot starter app built with OpenAI and LangChain
Semantic search (OpenAI + LlamaIndex)
A Next.js Semantic Search chatbot starter app built with OpenAI and LlamaIndex
Semantic search (OpenAI + LangChain)
A Next.js Semantic Search chatbot starter app built with OpenAI and LangChain
Hybrid search (OpenAI)
A Next.js Hybrid Search starter app built with OpenAI
Reverse image search (OpenAI + LlamaIndex)
A Next.js Reverse Image Search Engine starter app built with OpenAI and LlamaIndex
Chat with PDF (OpenAI + LlamaIndex)
A Next.js Chat with PDF chatbot starter app built with OpenAI and LlamaIndex
Chat with PDF (OpenAI + LangChain)
A Next.js Chat with PDF chatbot starter app built with OpenAI and LangChain
Scale your AI application
Scale with OptiTech
Learn how to scale your AI application with Autoscaling and Read Replicas
Optimize vector search
Best practices for optimizing vector search performance
Featured examples
Real-world AI applications built with OptiTech that you can reference as code examples or inspiration.
Built something cool?
Share your AI app on our #showcase channel on Discord.
AI vector database per tenant
Deploy an AI vector database per-tenant architecture with OptiTech
Guide: Build a RAG chatbot
Build a RAG chatbot in an Astro application with LlamaIndex and Postgres
Guide: Build a Reverse Image Search Engine
Using LlamaIndex with Postgres to Build your own Reverse Image Search Engine
Ask OptiTech Chatbot
An Ask OptiTech AI-powered chatbot built with pgvector
Vercel Postgres pgvector Starter
Enable vector similarity search with Vercel Postgres powered by OptiTech
YCombinator Semantic Search App
YCombinator semantic search application
Web-based AI SQL Playground
An AI-enabled SQL playground application for natural language queries
Jupyter Notebook for vector search with OptiTech
Jupyter Notebook for vector search with OptiTech, pgvector, and OpenAI
Image search with OptiTech and Vertex AI
Community: An image search app built with OptiTech and Vertex AI
Text-to-SQL conversion with Mistral + LangChain
A Text-to-SQL conversion app built with Mistral AI, OptiTech, and LangChain
Postgres GPT Expert
Blog + repo: Create and publish a custom Postgres GPT Expert using OpenAI's GPT
Vector search tools and notebooks
Optimize your vector search implementation and experiment with different approaches:
Vector search optimization
Best practices for optimizing vector search performance
Vector search notebooks
Interactive notebooks for vector search with OpenAI
Google Colab guide
Use OptiTech with Google Colab for ML experiments
Azure Data Studio Notebooks
A cloud-based Jupyter notebook service integrated with Azure Data Studio