Databases

Write MongoDB queries, aggregation pipelines and indexes and design schemas

Tune PostgreSQL queries and indexes and handle database administration

Use Redis data structures, caching patterns, Lua scripts and cluster setups

Tune SQLite with WAL mode, query plans and embedded database patterns

Pick vector databases and build embedding search, RAG indexes and similarity queries

Review Django migrations for PostgreSQL safety, indexes and data backfills

Design PostgreSQL indexes and validate them with EXPLAIN ANALYZE

Store embeddings and metadata in Chroma for semantic search and RAG retrieval

Run fast k-NN similarity search over billions of dense vectors with FAISS

Use the Pinecone managed vector database for low-latency hybrid search at scale

Build hybrid vector search with filtering in Qdrant for production RAG systems

Speed up slow PostgreSQL and MySQL queries with execution plans, indexes and tuning

Optimize PostgreSQL queries, replication, JSONB use and VACUUM tuning

Inspect, query and safely modify the MoviePilot database without exposing credentials

Point Aurora DSQL schema, query and migration questions to current guidance

Point Aurora DSQL questions to the current distributed SQL guidance

Point AWS DSQL questions to the current distributed SQL guidance

Point distributed Postgres questions to the current Aurora DSQL guidance

Point distributed SQL questions to the current Aurora DSQL guidance

Point DSQL schema, query and migration questions to current guidance

Analyze PostgreSQL performance decisions from a measurement-driven engineering viewpoint

Write illustrated database course articles on storage, indexes, types and optimizers

Answer PostgreSQL and database questions in the style of a long-running technical blog

Answer PostgreSQL behavior and internals questions from the source tree and docs

Apply Supabase Postgres best practices to queries, schemas and database settings

Choose and use Vercel Blob, Edge Config, Neon Postgres and Upstash Redis

Write type-safe SQL queries and schemas in TypeScript with Drizzle ORM

Build React and Expo apps on InstantDB as a real-time backend

Connect to Neon Postgres with pooling, branching, migrations and autoscaling

Run the Prisma 7 CLI for init, generate, migrate, db and studio commands

Write Prisma Client queries with filters, operators and transactions

Set up Prisma ORM through the legacy compatibility name for older integrations

Run Prisma Postgres setup through its legacy name for existing integrations

Choose Redis data structures and key names for caches, counters and leaderboards

Review Rails database migrations for zero-downtime changes and safe backfills

Build SQLAlchemy models and queries with relationships and Alembic migrations

Review SQLAlchemy models and Alembic migrations for safe, performant schemas

Run SQL, manage edge functions and migrations, and check Supabase project health

Find and fix slow EF Core queries, extra round-trips and hidden SaveChanges calls

Set up mirrord database branches for isolated Postgres, MySQL and Redis test copies

Store and query user data in HTML micro-apps with MagicBase rows and permissions

Store typed entities and relations in an append-only TSV knowledge graph

Find slow queries, read execution plans and tune indexes and configuration

Explore SQLite and Postgres schemas, preview tables and draw ER diagrams

Create and manage MySQL databases, users and access rights on a BaoTa panel

Pick a beginner, intermediate or advanced path to scaffold an Oracle AI Database project

Scaffold LangChain vector stores and chat history on Oracle with langchain-oracledb

Start Oracle 26ai Free in Docker with an app user and a ready-to-use env file

Set up a read-only PostgreSQL role for agent access