Manages and rebuilds high-performance FTS5 full-text search and FAISS semantic vector indexes for research data.
Set up and optimize search engines for applications.
Implement search features using Meilisearch, Typesense, Algolia, ElasticSearch, OpenSearch, or PostgreSQL full-text search.
Postgres performance optimization and best practices from Supabase.
Fill a PostgreSQL database with realistic, relationally valid test data using Seedfast.
Scans the current Go project and identifies the Service → Module → Resource hierarchy for tenant-manager registration.
Guide the user through connecting a new data warehouse source — Postgres, MySQL, Stripe, Hubspot, MongoDB, Salesforce, BigQuery…
Create, consume, or manage MotherDuck data shares, including audience grants, table filters, and refresh policy.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL…
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…
Comprehensive database design tool creating complete schemas with tables, fields, indexes, and ER diagrams.
Use when hardening the reproducibility story of a SIGMOD submission, covering PACMMOD's expectation that code, data, scripts, and…
Sizes a Qdrant deployment before it is provisioned.
Comprehensive guide to designing reliable, scalable data systems covering databases, streaming, and consistency
Execute SQL, manage Snowflake objects, and deploy applications using the Snowflake CLI command-line tool.
Implement Snowflake data governance with masking policies, row access policies, tagging, and GDPR/CCPA compliance patterns.
Execute Snowflake incident response with triage, rollback, and postmortem
Handle Snowflake concurrency limits, warehouse queuing, and query throttling.
Design robust, scalable database schemas for SQL and NoSQL databases.
Use when configuring or working with Solid Cache for database-backed caching.