Api Filtering Sorting

Handles the common pattern of turning URL query parameters into database filters and sorts, with built-in security through field whitelisting. The implementation shows MongoDB-style operators (gte, lte, in, like) parsed from bracket syntax like price[gte]=100, plus multi-field sorting with direction indicators. Worth noting it includes type coercion for booleans and numbers, which saves you from string comparison bugs. The security model is straightforward: explicitly allow which fields can be filtered or sorted, then validate everything else. If you're building any kind of search or list endpoint, this gives you a solid starting point that's more thought-through than what you'd probably write in fifteen minutes.

Install to Claude Code

npx -y skills add secondsky/claude-skills --skill api-filtering-sorting --agent claude-code