Api Filtering Sorting

This handles the classic API filtering and sorting problem: turning query parameters into safe, performant database queries. You get query parsing, field whitelisting, and validation patterns for MongoDB, SQLAlchemy, and Elasticsearch. The skill covers the whole chain from parsing ?category=shoes&minPrice=50 to building optimized database queries without opening yourself up to injection attacks. Most useful when you're building search interfaces or flexible data APIs and don't want to reinvent parameter parsing for the hundredth time. The reference guides include a filter builder pattern and faceted navigation examples, which beats cobbling together regex parsers and hoping for the best.

skills.sh installs: 450
GitHub stars: 379
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill api-filtering-sorting --agent claude-code

Installs into .claude/skills of the current project.

Files

Overview

Build flexible filtering and sorting systems that handle complex queries efficiently with proper validation, security, and performance optimization.

When to Use

Building search and filter interfaces
Implementing advanced query capabilities
Creating flexible data retrieval endpoints
Optimizing query performance
Validating user input for queries
Supporting complex filtering logic

Quick Start

Minimal working example:

// Node.js filtering implementation
app.get("/api/products", async (req, res) => {
  const filters = {};
  const sortOptions = {};

  // Parse filtering parameters
  const allowedFilters = [
    "category",
    "minPrice",
    "maxPrice",
    "inStock",
    "rating",
  ];
  for (const key of allowedFilters) {
    if (req.query[key]) {
      filters[key] = req.query[key];
    }
  }

  // Build MongoDB query
  const mongoQuery = {};

SKILL.md on GitHub