Results for “indexing”

Quick reference for PostgreSQL best practices covering query optimization, schema design, indexing, Row Level Security, and connection pooling.

Provides best practices for optimizing MariaDB queries, including indexing strategies, EXPLAIN analysis, pagination, histogram statistics, and MariaDB-specific optimizer settings.

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues using execution plan analysis, indexing strategies, and set-based operations.

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

Automate Google Search Console tasks including search performance analysis, URL inspection, sitemap management, and indexing status checks via Composio's Rube MCP toolkit.

Guides OLTP database schema design through six stages: domain and access patterns, entities and relationships, keys and constraints, normalization trade-offs, indexing and performance, and operations and evolution. Includes a final review checklist and tips for effective guidance.

Designs normalized database schemas, creates indexes, writes efficient queries, and manages transactions and data integrity.

Guides database index selection, creation, and maintenance with SQL examples for PostgreSQL and MySQL.

Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.

Indexes local files and searches them with BM25, vector, and hybrid queries, plus MCP mode.

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Provides JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

Read and query onchain data using events, The Graph, Dune, Ponder, Multicall3, and WebSocket subscriptions, with guidance on block iteration limitations.

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Executes MySQL database development and review tasks based on user-provided rules, covering naming constraints, index design, and data archiving for large datasets.

Designs Elasticsearch indexes and mappings, tunes queries, sizes clusters, and handles operations like shard/replica strategy, ILM, monitoring, troubleshooting, and safe reindexing or upgrades.

Always start with EXPLAIN ANALYZE to understand execution:

Index local folders and search documents with BM25, vector, or hybrid queries, plus AI answers with citations and a web UI.

Ingest, index, search, edit, and generate video and audio content from files, URLs, live streams, or desktop capture.

`analysis-agent`/`task-agent`/`review-agent`: use for search relevance, freshness, analytical grain, metrics, or rebuilds; skip bounded source queries and operational telemetry.

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

Optimize PostgreSQL queries, configure replication, and implement advanced database features with EXPLAIN analysis, JSONB operations, extension usage, and VACUUM tuning.

Index local folders and search documents with BM25, vector, or hybrid queries, plus AI answers with citations and a web UI.

Provides guidance and code for production AI workflows including RAG pipelines, vector databases, embedding indexing, prompt engineering, cost estimation, semantic caching, and quality evaluation.

Provides JPA/Hibernate patterns for Spring Boot data modeling, including entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and connection pooling.

Ingests video and audio from files, URLs, and live streams, builds searchable visual and spoken indexes, edits timelines with subtitles and overlays, and generates real-time alerts.

Index folders of PDFs and other documents into LanceDB for vector search, then query them with semantic search, page filters, verbatim quotes, and cross-document aggregation.

Builds production RAG and semantic search systems with Qdrant, covering collection setup, vector indexing, filtered and hybrid search, and integration with LangChain and LlamaIndex.

Vector embeddings with HNSW indexing, sql.js persistence, and hyperbolic support. 75x faster with agentic-flow integration. Use when: semantic search, pattern matching, similarity queries, knowledge retrieval. Skip when: exact text matching, simple lookups, no semantic understanding needed.

Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. Use when the user provides a query, performance symptom, or EXPLAIN plan; use sql-query-generation when creating a new query from requirements.