Does this support multiple different limits?

Absolutely. The skill includes instructions for adding new columns to the usage_tracking table so you can monitor and limit different features separately.

What database does this skill use?

The implementation is designed for use with Drizzle ORM, making it compatible with any SQL database (like PostgreSQL or MySQL) supported by Drizzle.

Can I modify the reset window?

Yes, the logic includes a reset condition currently set to 24 hours, which can be easily adjusted in the code to enforce hourly, weekly, or custom intervals.

How are users identified without accounts?

The skill uses a SHA-256 hash combining the user's IP address and User-Agent string to create a consistent but anonymous identifier for tracking requests.

What response code is used when a limit is exceeded?

The skill implements the standard HTTP 429 (Too Many Requests) status code, which is the industry standard for rate-limited responses.

API Rate Limiting & Usage Tracking

Name: API Rate Limiting & Usage Tracking
Author: AppleLamps

byAppleLamps

0•

API Development

Implements robust, database-backed rate limiting and usage tracking for API endpoints to prevent abuse and manage resource quotas.

This skill provides a standardized pattern for implementing anonymous rate limiting in Next.js applications using Drizzle ORM and a SHA-256 hashing mechanism for user identification. It allows developers to enforce daily limits on specific features—such as image generation or API requests—while handling usage resets automatically every 24 hours. By returning standard HTTP 429 responses and keeping identifiers anonymous, it helps developers maintain application stability, protect against resource exhaustion, and ensure cost control without compromising user privacy.

Key Features

010 GitHub stars

02Drizzle ORM integration for efficient usage state management

03Extensible schema support for tracking multiple features independently

04Standardized HTTP 429 (Too Many Requests) error handling

05Anonymous user identification via SHA-256 IP and User-Agent hashing

06Database-backed tracking with automatic 24-hour reset logic

Use Cases

01Tracking and enforcing usage limits for premium features in a SaaS application

02Limiting expensive AI-powered image generation to a specific daily quota per user

03Implementing request throttling for public API endpoints to prevent scraping or abuse

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add applelamps/grokify rate-limit-setup

For use in Claude.ai and ChatGPT

Download Skill