database-patterns Cursor ruleA

database-patterns from brendadeeznuts1111/betting-brain-v3 is a Cursor rule: instructions the Cursor agent follows in that repo.

Install it, pinned
mdr add brendadeeznuts1111/betting-brain-v3/.cursor/rules/database-patterns.mdc@v2.0.0

Pins v2.0.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 14 of 14 checks passed
Kind
Cursor rule
Repository
brendadeeznuts1111/betting-brain-v3
Path
.cursor/rules/database-patterns.mdc
Versions recorded
3
Latest version
v2.0.0, committed Oct 8, 2025
First version recorded
Oct 8, 2025
Size
7,700 bytes
Repository stars
8
License
MIT

Database patterns and D1 query best practices.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Database Patterns

## 🔍 Code Searchability Patterns

### Find database-patterns Issues with ast-grep

```bash
# Find env.$DB.prepare($QUERY)
# Find await stmt.bind($$$).all()
# Find await stmt.bind($$$).first()
# Find normalizeD1Result<$$$>($$$)
ast-grep --pattern 'env.$DB.prepare($QUERY)' src/
ast-grep --pattern 'await stmt.bind($$$).all()' src/
ast-grep --pattern 'await stmt.bind($$$).first()' src/
ast-grep --pattern 'normalizeD1Result<$$$>($$$)' src/
sg -p 'env.$DB.prepare($QUERY)' src/
sg -p 'await' src/
sg -p 'await' src/
sg -p 'normalizeD1Result<$$$>($$$)' src/
```

### database-patterns Discovery Commands

```bash
sg search "env.ANALYTICS.prepare" src/
sg search "normalizeD1Result" src/
sg search ".bind(" src/
sg search ".all()" src/
```

### Search Examples

```bash
# Find all database queries
sg search 'env.$DB.prepare($QUERY)' src/
# Find D1 result normalization
sg search 'await' src/
# Find parameterized queries
sg search 'await' src/
# Find query execution patterns
sg search 'normalizeD1Result<$$$>($$$)' src/
```
## D1 Database Usage

### Environment Bindings

**Primary Databases:**
- `ANALYTICS` - Main betting analytics database
- `RAW_FEED_DB` - Raw feed database
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add brendadeeznuts1111/betting-brain-v3/.cursor/rules/database-patterns.mdc@sha256:6c2870855ffe20c3

The line at the top of this page pins the label v2.0.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_zfxb42pxwteuyteh.svg)](https://markdownregistry.com/a/art_zfxb42pxwteuyteh)

2 badge image fetches in 30 days. What the badge shows.

Ask from your agent
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry

Then ask it: what changed in brendadeeznuts1111/betting-brain-v3/.cursor/rules/database-patterns.mdc since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.

Got a copy of database-patterns.mdc from somewhere else? Ask it: where did my database-patterns.mdc come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.

Versions

The registry has recorded 3 versions of this file, all committed on Oct 8, 2025.

Watch this file (sign in, one email per new version)

versioncommittedcommitsizeaudit
v2.0.0 latest2025-10-08 154694c 7,700 BA view · diff
v2.0.02025-10-08 cb2a4d8 6,617 BA view · diff
git:20251008.4a59e8e2025-10-08 4a59e8e 5,374 BA view
Check a whole project

From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies

In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies

No sha256sum on your machine? shasum -a 256 prints the same lines.

Audit of the latest version

A  14 of 14 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Size between 200 bytes and 200 KB (7700 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

brendadeeznuts1111/betting-brain-v3 · 8 stars · license MIT · pushed 2026-11-10 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_zfxb42pxwteuyteh
GET https://markdownregistry.com/api/v1/resolve?ref=brendadeeznuts1111/betting-brain-v3/.cursor/rules/database-patterns.mdc
GET https://markdownregistry.com/api/v1/blob/6c2870855ffe20c38f4f88f9236d253a172f0196b962d5146323f81f862354dc

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: Cursor rules vs AGENTS.md · which agent file does what.

More from brendadeeznuts1111/betting-brain-v3

99-floor Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/99-floor.mdc · AI Floor - Single source of truth for autonomous operations
v3.3.0 · audit A · 8 stars
ai-friendly-testing Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/ai-friendly-testing.mdc · AI-friendly testing patterns and Bun test integration
v1.0.0 · audit A · 8 stars
analytics-stub-api Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/analytics-stub-api.mdc · AnalyticsEngineStub API patterns and usage
v1.1.0 · audit A · 8 stars
analytics-testing Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/analytics-testing.mdc · Analytics testing patterns and best practices
v1.1.0 · audit A · 8 stars
api-patterns Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/api-patterns.mdc · API endpoint patterns and request handling conventions
v5.0.0 · audit A · 8 stars
browser-extension Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/browser-extension.mdc · Browser extension patterns and development practices
v1.0.0 · audit B · 8 stars
bun-runtime Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/bun-runtime.mdc · Bun runtime patterns and best practices
v5.0.0 · audit A · 8 stars
cache-optimization Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/cache-optimization.mdc · Fantasy402 cache optimization patterns and performance guidelines
v1.0.0 · audit A · 8 stars
ci-integration Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/ci-integration.mdc · CI/CD integration patterns and automation
v1.1.0 · audit A · 8 stars
ci-patterns Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/ci-patterns.mdc · CI/CD patterns and automation best practices
v1.0.0 · audit A · 8 stars
cloudflare-infrastructure Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/cloudflare-infrastructure.mdc · Cloudflare infrastructure patterns and best practices
v1.0.0 · audit A · 8 stars
cloudflare-workers Cursor rule
brendadeeznuts1111/betting-brain-v3 · .cursor/rules/cloudflare-workers.mdc · Cloudflare Workers specific patterns and requirements
v2.0.0 · audit A · 8 stars

Every file in brendadeeznuts1111/betting-brain-v3

Other files named database-patterns

database-patterns SKILL.md skill
yonatangross/orchestkit · plugins/ork/skills/database-patterns/SKILL.md · Schema design, Alembic migrations and database versioning. Use when creating migrations, designing or normalizing…
v2.0.0 · audit A · 304 stars
database-patterns SKILL.md skill
yonatangross/orchestkit · src/skills/database-patterns/SKILL.md · Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning. Use…
v2.0.0 · audit A · 304 stars
database-patterns SKILL.md skill
majiayu000/spellbook · skills/database-patterns/SKILL.md · Use when designing PostgreSQL + Redis data models, indexes, caching strategies, JSONB usage, tiered storage, or cache…
git:20260605.a09e45c · audit A · 297 stars

Browse by kind, by grade A, or by owner.