Databases

Write Exposed Kotlin ORM code with DSL and DAO queries, transactions and migrations

Design MySQL and MariaDB schemas and indexes that hold up in production

Optimize PostgreSQL queries and design schemas, indexes and row-level security

Write Prisma queries with safe transactions, pagination and fixes for common traps

Design Redis caches, distributed locks, rate limits and pub/sub for production apps

Store embeddings in Chroma for RAG and semantic search

Run fast vector similarity search at billion scale with FAISS

Store and search embeddings in managed Pinecone for production RAG

Set up Qdrant vector search for production RAG and similarity lookups

List, create, import and query n8n data tables and their columns

Create a sequentially numbered database migration with up and down SQL files

Check pending migrations for foreign key issues and rollback safety

Generate 384-dimension text embeddings with ONNX and store them in an HNSW index

Run HNSW vector search with 1-bit RaBitQ quantization to cut memory use

Set up ruvector with ONNX add-ons, register its MCP server and run a health check

Automate Influxdb Cloud tasks with the Rube MCP toolkit from Composio

Manage Neon serverless Postgres projects, branches, roles and connection URIs

Automate Ninox no-code database tasks through the Composio Rube MCP server

Automate Prisma database and ORM tasks through the Composio Rube MCP server

Automate Ragic online database and form tasks through the Composio Rube MCP server

Manage Turso edge SQLite databases and access tokens through Composio Rube MCP

Review database migrations for rollback safety, locking and data risks before merge

Manage ChromaDB vector collections, documents and semantic search from the terminal

Edit Prisma 8 contract files, plan migrations and run contract emit in projects

Run zero-downtime database schema migrations with data transforms and rollbacks

Design and build event stores for event-sourced systems and their persistence

Design PostgreSQL schemas with proper data types, indexes and constraints

Build read models and materialized views from event streams for CQRS queries

Implement nearest neighbor search and semantic queries in vector databases

Tune HNSW settings and quantization for latency, recall and memory use

Design Azure Cosmos DB NoSQL data models from application requirements

Build a master plan for migrating .NET projects from Oracle to PostgreSQL

Write bug reports for Oracle to PostgreSQL behavior gaps with severity and fixes

Apply Entity Framework Core best practices to data models and queries

Fix Hibernate and JPA problems such as N+1 queries, lazy loading and cascades

Migrate .NET data access code from Oracle to PostgreSQL with Npgsql

Translate Oracle PL/SQL stored procedures into PostgreSQL PL/pgSQL

Build RAG pipelines and agent memory on Pinecone for semantic search and retrieval

Review PostgreSQL code for JSONB, array, schema and Row Level Security issues

Use PostgreSQL-specific types, full-text search, window functions and extensions well

Connect to Qdrant from your app using its official client SDKs

Choose how to deploy Qdrant among Docker, cloud, local, embedded and edge

Plan Qdrant horizontal scaling with node counts, shards and resharding

Diagnose and fix slow Qdrant indexing, uploads and optimizer stalls

Diagnose and reduce high Qdrant memory use, crashes and out-of-memory errors

Reduce Qdrant query latency, tail latency and sudden latency spikes

Switch embedding models in Qdrant with zero downtime and re-embedded vectors

Set up Qdrant monitoring with metrics to track, health checks and alerts

Diagnose stuck optimizers, memory spikes and slow queries in Qdrant production