Databases

Write efficient PostgreSQL queries with sound indexes, schemas and security

Design database schemas as visual entity relationship diagrams

Design PostGIS spatial tables with geometry types, coordinate systems and indexes

Design PostgreSQL tables with suitable data types, constraints and indexes

Find existing PostgreSQL tables that should become TimescaleDB hypertables

Migrate PostgreSQL tables to TimescaleDB hypertables with minimal downtime

Set up pgvector semantic search for embeddings, RAG and nearest-neighbor queries

Explore, design and migrate PostgreSQL databases with pgvector and TimescaleDB

Test and run risky PostgreSQL schema migrations safely on live databases

Combine BM25 keyword and pgvector search in Postgres with reciprocal rank fusion

Create TimescaleDB hypertable schemas for time-series, metrics, IoT and log data

Explain transaction concurrency control, serializability and isolation anomalies

Turn concurrency-control papers and specs into models with invariants

Reconstruct transaction behavior from logs and traces with evidence-based analysis

Run cloud databases with high availability, backups, disaster recovery and tuning

Design database schemas, pick technologies and plan migrations for new systems

Monitor database migrations with CDC, metrics and observability

Plan zero-downtime SQL migrations for PostgreSQL, MySQL and SQL Server

Tune query performance with indexing, caching, partitioning and N+1 fixes

Design PostgreSQL schemas with data types, constraints, indexes and advanced features

Tune SQL queries, optimize databases and model data for OLTP and OLAP

Design vector indexes and semantic search with Pinecone, Qdrant, Milvus or pgvector

Create and govern RDF and OWL ontologies through the Open Ontologies MCP server

Build, validate and query RDF and OWL ontologies with SPARQL and SHACL

Avoid Room, SQLite and DataStore traps in migrations, queries and paging

Fix JPA and Hibernate issues like N+1 queries, lazy loading and transaction bugs

Design schemas, indexes and migrations and fix N+1 query problems

Build retrieval with vector databases, hybrid search and reranking

Run T-SQL, deploy dacpacs and investigate query plans in a Fabric SQL database

Design schemas, tune queries and pick Postgres, Mongo, Redis or cloud databases

Choose and set up Neon, Supabase or Firestore for serverless and real-time apps

Avoid N+1 queries and slow reads with EF Core and Dapper access patterns

Apply Entity Framework Core best practices for tracking, queries and migrations

Review Core Data models for schema migration risks and data safety

Audit SQLite and GRDB schema and migrations for safety before release

Find slow GRDB queries and broken ValueObservation updates before release

Review SwiftData models, migrations and query performance in Apple apps

Build Apple app storage with SwiftData, Core Data, GRDB, CloudKit or Realm

Read, write and update relational databases from MATLAB with sqlread and sqlwrite

Tune MongoDB client connection pools, timeouts and patterns in any driver language

Turn plain-language questions into read-only MongoDB find queries and pipelines

Diagnose slow MongoDB queries and recommend indexes and query fixes

Design MongoDB schemas with embed or reference choices and no unbounded arrays

Build MongoDB Atlas Search, vector and hybrid search for text and semantic queries

Apply Postgres best practices to schema design, column types, migrations and RLS

Provision RDS databases with backups, replication and security settings

Provision Azure SQL Database and Cosmos DB with backups, replication and security

Set up automated database backups with retention and tested recovery procedures

Provision Cloud SQL and Spanner with high availability, backups and security