ReddRadar
Agent skill
db-explorer
MongoDB database exploration and querying. Use when you need to understand database structure, view existing data, check collection schemas, count documents, or run queries to investigate the database state. (project)
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/db-explorer
SKILL.md
MongoDB Database Explorer
Use this skill when you need to explore the MongoDB database to understand data structure, verify existing records, or investigate database state.
When to Use
- Understanding what data exists in collections
- Checking collection schemas and indexes
- Counting documents matching certain criteria
- Viewing sample documents
- Debugging data-related issues
- Verifying database state after operations
Quick Exploration Commands
Use mongosh or a MongoDB client to explore the database:
# Connect to MongoDB
mongosh mongodb://localhost:27017/freelancelyst
# Show all collections
show collections
# Count documents in a collection
db.users.countDocuments()
db.blogposts.countDocuments()
# View sample documents
db.users.find().limit(5).pretty()
db.blogposts.find().limit(5).pretty()
# Query with filters
db.blogposts.find({ status: "published" }).limit(10).pretty()
db.users.find({ roles: "admin" }).pretty()
# Aggregate examples
db.blogposts.aggregate([
{ $group: { _id: "$status", count: { $sum: 1 } } }
])
Database Schema Overview
The database has the following collections:
Users
Collection: users
{
_id: ObjectId,
name: string,
email: string,
password: string, // bcrypt hashed
roles: string[], // ['user'] or ['admin']
createdAt: Date,
updatedAt: Date
}
Blog Posts
Collection: blogposts
{
_id: ObjectId,
slug: string, // unique
status: 'draft' | 'published' | 'archived',
publishedAt: Date | null,
coverImage: string | null,
owner: ObjectId, // ref: users
category: ObjectId | null, // ref: blogcategories
tags: ObjectId[], // refs: blogtags
translations: [
{ langCode: 'en' | 'fa', title: string, content: string, excerpt: string }
],
createdAt: Date,
updatedAt: Date
}
Blog Categories
Collection: blogcategories
{
_id: ObjectId,
slug: string, // unique
translations: [
{ langCode: 'en' | 'fa', name: string }
],
createdAt: Date,
updatedAt: Date
}
Blog Tags
Collection: blogtags
{
_id: ObjectId,
slug: string, // unique
translations: [
{ langCode: 'en' | 'fa', name: string }
],
createdAt: Date,
updatedAt: Date
}
Project Applications
Collection: projectapplications
{
_id: ObjectId,
title: string,
description: string,
budgetEstimate: string,
deadline: string,
clientEmail: string | null,
utm: object | null, // UTM tracking params
createdAt: Date,
updatedAt: Date
}
Freelancer Applications
Collection: freelancerapplications
{
_id: ObjectId,
fullName: string,
email: string,
skillTags: string,
description: string,
utm: object | null, // UTM tracking params
createdAt: Date,
updatedAt: Date
}
Common Queries
Find posts with translations in specific language
db.blogposts.find({
"translations.langCode": "en"
}).pretty()
Get published posts with category populated
db.blogposts.aggregate([
{ $match: { status: "published" } },
{ $lookup: {
from: "blogcategories",
localField: "category",
foreignField: "_id",
as: "categoryData"
}},
{ $limit: 5 }
])
Count applications by month
db.projectapplications.aggregate([
{ $group: {
_id: { $month: "$createdAt" },
count: { $sum: 1 }
}}
])
Important Notes
- Environment: Ensure
MONGODB_URIis set in your.env.localfile - Read-Only: This skill is for exploration only. Never modify data through raw queries.
- Sensitive Data: Be careful with password hashes - don't log them in plain text
- Performance: Use limits on large collections to avoid slow queries
- Translations: Remember blog entities use embedded translation arrays
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?