All categories
Databases
SQL, NoSQL, schema design, migrations, ORMs, and database operations
- 4,325
- 181
Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.
Open in full browserBrowse databases skills
Showing 3,265–3,288 of 4,325 skills
- 168 Sql 61f5b3c5```sql -- Basic EXPLAIN ANALYZE EXPLAIN (ANALYZE, BUFFERS, VERBOSE) SELECT u.id, u.name, COUNT(o.id) as order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.created_at > '2024-01-01' GROUP BY u.id, u.name;Votes: 0GitHub stars: 4
- 2515 Tactical Checklist C6fefa0a- One aggregate root per transaction boundary - Invariants enforced inside aggregate methods - Avoid cross-aggregate synchronous consistency rulesVotes: 0GitHub stars: 4
- 2504 02 Requirementsagent 6a3a80b5Researches and captures Azure infrastructure project requirementsVotes: 0GitHub stars: 4
- 2480 Design 7f4154fc当前系统使用插件化架构管理数据源,每个插件通过 `config.json` 定义调度频率(daily/weekly)。但数据管理界面仅返回Mock数据,无法: 1. 检测基于交易日的数据缺失 2. 展示同步任务执行状态 3. 直接查看插件数据Votes: 0GitHub stars: 4
- 2478 Proposal 907f2a23当前系统缺少ETF(交易型开放式指数基金)相关的数据获取插件,无法支持: 1. **ETF基础信息**:无法获取国内ETF的基础信息(代码、名称、管理人、跟踪指数等) 2. **ETF日线行情**:无法获取ETF每日收盘后的OHLCV数据 3. **ETF复权因子**:无法获取ETF的复权因子,影响价格调整计算 4. **ETF分钟数据**:无法获取ETF的分钟级别行情数据Votes: 0GitHub stars: 4
- 2351 Captureknowledge D2208935Extract insights from conversations and save them as vault notes.Votes: 0GitHub stars: 4
- 2351 Captureknowledge B53befc7Extract insights from conversations and save them as vault notes.Votes: 0GitHub stars: 4
- 2106 Fairdb Health Check 40a682c9Comprehensive health check for FairDB PostgreSQL infrastructureVotes: 0GitHub stars: 4
- 2105 Fairdb Emergency Response Eff1dd55Emergency incident response procedures for critical FairDB issuesVotes: 0GitHub stars: 4
- 2097 Daily Health Check Bb48daa3Execute SOP-101 Morning Health Check Routine for all FairDB VPS instancesVotes: 0GitHub stars: 4
- 2036 Errors 09c9caf0| Error | Cause | Solution | |-------|-------|----------| | `Missing errors during migration` | Sampling mismatch | Run both tools at 100% during parallel | | `Alert parity issues` | Different alert models | Map alert rules carefully before cutover | | `Data export failed` | API rate limits | Use pagination and backoff | | `Team unfamiliar with UI` | No training | Schedule Sentry training sessions |Votes: 0GitHub stars: 4
- 1557 Architectagent A6e33558Expert Architect providing guidance using Azure Well-Architected Framework principles and Microsoft best practices. Evaluates all decisions against WAF pillars (Security, Reliability, Performance, Cost, Operations) with Microsoft documentation lookups. Automatically generates cost estimates using Azure Pricing MCP tools. Saves WAF assessments and cost estimates to markdown documentation files.Votes: 0GitHub stars: 4
- 1557 Architectagent A5b83e17Expert Architect providing guidance using Azure Well-Architected Framework principles and Microsoft best practices. Evaluates all decisions against WAF pillars (Security, Reliability, Performance, Cost, Operations) with Microsoft documentation lookups. Automatically generates cost estimates using Azure Pricing MCP tools. Saves WAF assessments and cost estimates to markdown documentation files.Votes: 0GitHub stars: 4
- 1557 Architectagent 91884061Expert Architect providing guidance using Azure Well-Architected Framework principles and Microsoft best practices. Evaluates all decisions against WAF pillars (Security, Reliability, Performance, Cost, Operations) with Microsoft documentation lookups. Automatically generates cost estimates using Azure Pricing MCP tools. Saves WAF assessments and cost estimates to markdown documentation files.Votes: 0GitHub stars: 4
- 1557 Architectagent 7970d639Expert Architect providing guidance using Azure Well-Architected Framework principles and Microsoft best practices. Evaluates all decisions against WAF pillars (Security, Reliability, Performance, Cost, Operations) with Microsoft documentation lookups. Automatically generates cost estimates using Azure Pricing MCP tools. Saves WAF assessments and cost estimates to markdown documentation files.Votes: 0GitHub stars: 4
- 1540 Requirementsagent D08357c0Researches and captures Azure infrastructure project requirementsVotes: 0GitHub stars: 4
- 1540 Requirementsagent 1943d41cResearches and captures Azure infrastructure project requirementsVotes: 0GitHub stars: 4
- 1540 Requirementsagent 0c3bbb4aResearches and captures Azure infrastructure project requirementsVotes: 0GitHub stars: 4
- 1531 Entities 01845d59Represents domain objects for use in App Intents:Votes: 0GitHub stars: 4
- 081 Troubleshooting 7c93e51bThis guide covers common issues and their solutions when running ContextForge. ---Votes: 0GitHub stars: 4
- 081 Troubleshooting 4f47dc6bSolutions to common issues and error conditions.Votes: 0GitHub stars: 4
- 076 Api A71b2d70All methods are exposed as MCP tools.Votes: 0GitHub stars: 4
- 076 Api 7e7bb032See [README.md](./README.md) for overview, [configuration.md](./configuration.md) for setup.Votes: 0GitHub stars: 4
- 076 Api 5eb669f0See [README.md](./README.md) for overview, [configuration.md](./configuration.md) for setup.Votes: 0GitHub stars: 4