Search and Filter Tools

Powerful search and filtering capabilities exposed as first-class MCP tools. Let agents narrow datasets at the source for optimal performance.

Advanced Filtering

Every API filter becomes a typed parameter that agents can use intelligently.

{
  "tool": "products.search",
  "arguments": {
    "filters": {
      "category": "electronics",
      "price_range": [100, 500],
      "rating_min": 4.0,
      "in_stock": true,
      "brand": ["Apple", "Samsung"]
    }
  }
}
✓Type-safe filter parameters
✓Server-side execution
✓Combinable filter logic

Smart Sorting

Multi-field sorting with clear precedence and direction control.

{
  "tool": "orders.list",
  "arguments": {
    "sort": [
      {"field": "created_at", "order": "desc"},
      {"field": "total", "order": "desc"},
      {"field": "customer_id", "order": "asc"}
    ]
  }
}
✓Multi-field sorting
✓Stable sort guarantees
✓Custom comparators

Search Capabilities

Full-Text Search

  • • Natural language queries
  • • Fuzzy matching
  • • Relevance scoring
  • • Highlighting support

Faceted Search

  • • Dynamic facets
  • • Count aggregations
  • • Range buckets
  • • Multi-select filters

Semantic Search

  • • Vector similarity
  • • Hybrid scoring
  • • Concept matching
  • • Query expansion

Filter Types

Comparison Filters

price_gt: 100
rating_gte: 4.0
created_before: "2025-08-25"
quantity_lte: 10

Inclusion Filters

status_in: ["active", "pending"]
category_not_in: ["archived"]
tags_contains: "featured"
ids: [1, 2, 3]

Pattern Filters

name_like: "%phone%"
email_regex: ".*@company.com"
path_prefix: "/products/"
case_sensitive: false

Range Filters

price_between: [50, 200]
date_range: {
  from: "2025-01-01",
  to: "2025-12-31"
}

Existence Filters

has_discount: true
image_exists: true
description_not_null: true
metadata_empty: false

Logical Operators

_or: [
  {price_lt: 50},
  {discount_gte: 20}
]
_not: {status: "deleted"}

💡 Pro Tip: Let the Database Do the Work

Always prefer server-side filtering over client-side. MCPify exposes native database capabilities directly to agents, ensuring optimal query execution plans and minimal data transfer.

Ready to give agents powerful search?

Get StartedTry in Playground