api-filtering-sorting

Builds flexible API filtering and sorting systems with query parameter parsing, validation, and security. Use when implementing search endpoints, building data grids, or creating dynamic query APIs.

⭐9stars🔀0forks📁View on GitHub🕐Updated Jan 1, 2026⬇️2downloads

When & Why to Use This Skill

This Claude skill provides a comprehensive framework for building flexible and secure API filtering and sorting systems. It simplifies the implementation of complex query parameter parsing, supports various comparison operators (such as gte, lte, in, and like), and emphasizes security best practices like field whitelisting and input validation to prevent injection attacks and optimize database performance.

Use Cases

  • E-commerce Search Endpoints: Implementing multi-faceted search for product catalogs, allowing users to filter by price ranges, categories, and ratings while sorting by relevance or price.
  • Admin Dashboards: Powering dynamic data grids and tables that require real-time, multi-column sorting and complex filtering across large datasets.
  • Public API Development: Creating standardized, developer-friendly query interfaces that allow external users to fetch specific data subsets securely and efficiently.
  • Resource Management Systems: Building backend logic for applications that need to handle complex logical queries, such as filtering tasks by status, priority, and due date ranges.
nameapi-filtering-sorting
descriptionBuilds flexible API filtering and sorting systems with query parameter parsing, validation, and security. Use when implementing search endpoints, building data grids, or creating dynamic query APIs.

API Filtering & Sorting

Build flexible filtering and sorting systems that handle complex queries efficiently.

Query Parameter Syntax

GET /products?category=electronics&price[gte]=100&price[lte]=500&sort=-price,name

Implementation (Node.js)

const allowedFilters = ['category', 'status', 'price', 'createdAt'];
const allowedSorts = ['name', 'price', 'createdAt'];

app.get('/products', async (req, res) => {
  const filter = {};
  const sort = {};

  // Parse filters
  for (const [key, value] of Object.entries(req.query)) {
    if (key === 'sort') continue;

    const match = key.match(/^(\w+)\[(\w+)\]$/);
    if (match) {
      const [, field, operator] = match;
      if (!allowedFilters.includes(field)) continue;
      filter[field] = { [`$${operator}`]: parseValue(value) };
    } else if (allowedFilters.includes(key)) {
      filter[key] = value;
    }
  }

  // Parse sort
  if (req.query.sort) {
    for (const field of req.query.sort.split(',')) {
      const direction = field.startsWith('-') ? -1 : 1;
      const name = field.replace(/^-/, '');
      if (allowedSorts.includes(name)) sort[name] = direction;
    }
  }

  const products = await Product.find(filter).sort(sort);
  res.json({ data: products });
});

function parseValue(value) {
  if (value === 'true') return true;
  if (value === 'false') return false;
  if (!isNaN(value)) return Number(value);
  return value;
}

Filter Operators

Operator Meaning Example
eq Equals ?status=active
ne Not equals ?status[ne]=deleted
gt/gte Greater than ?price[gte]=100
lt/lte Less than ?price[lte]=500
in In array ?status[in]=active,pending
like Contains ?name[like]=phone

Security

  • Whitelist allowed filter fields
  • Validate input types per field
  • Index frequently-filtered columns
  • Limit query complexity
  • Prevent SQL/NoSQL injection

Best Practices

  • Support common operators
  • Cache filter option lists
  • Monitor query performance
  • Provide sensible defaults