community-feed
Provides database query patterns for building high-performance social media feeds with infinite scroll.
Install
mkdir -p .claude/skills/community-feed && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/5635" && unzip -o skill.zip -d .claude/skills/community-feed && rm skill.zipInstalls to .claude/skills/community-feed
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Social feed with batch queries, cursor pagination, trending algorithms, and engagement tracking. Efficient database queries for infinite scroll feeds.Key capabilities
- →Implement cursor-based pagination for large datasets
- →Calculate trending scores using engagement metrics and time decay
- →Batch-load related data to prevent N+1 query issues
- →Perform atomic counter updates for likes and engagement
- →Filter feed content by tags and user follow relationships
How it works
The service uses cursor-based pagination to fetch records and computes trending scores via a stored column that factors in engagement and age. It batches related user and asset data to optimize database performance.
Inputs & outputs
When to use community-feed
- →Implement cursor pagination
- →Build trending content logic
- →Optimize feed database queries
About community-feed
Implements efficient database strategies for social feeds including cursor-based pagination and engagement metrics. Offers logic for managing trending content algorithms.
Social feed with batch queries, cursor pagination, trending algorithms, and engagement tracking. Efficient database queries for infinite scroll feeds.
When not to use it
- →Using offset-based pagination for large datasets
- →Computing trending scores during every query execution
- →Performing non-atomic counter updates
Prerequisites
Limitations
- →Requires manual maintenance of computed trending score columns
- →Total count computation can be expensive for large datasets
How it compares
Unlike standard offset pagination which slows down as the dataset grows, this approach uses stable cursors for consistent performance on large feeds.
Compared to similar skills
community-feed side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| community-feed (this skill) | 1 | 6mo | No flags | Intermediate |
| prisma-database | 0 | 6mo | Review | Intermediate |
| ck:databases | 0 | 3mo | Review | Intermediate |
| database-design | 6 | 6mo | Review | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by dadbodgeoff
View all by dadbodgeoff →You might also like
prisma-database
slashwhy
Prisma schema conventions, migrations, seeding, and query patterns. Use when modifying database schema, creating migrations, or writing complex queries.
ck:databases
lengo0951
Design schemas, write queries for MongoDB and PostgreSQL. Use for database design, SQL/NoSQL queries, aggregation pipelines, indexes, migrations, replication, performance optimization, psql CLI.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
vector-database-engineer
sickn33
Expert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, and pgvector for RAG applications, recommendation systems, and similar
generating-database-seed-data
jeremylongshore
Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.