supabase
Handles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...
managing-jira-issues
Jira issue management using the jira CLI with JSON output. Use for creating, viewing, updating, searching issues, fetching complete hierarchies, and managing sprints.
Full skill instructions
Purpose: Issue management for Jira Cloud using the jira CLI with JSON output optimized for LLM agents.
Tool: jira CLI (installed globally via npm link from ~/utils/atlassian)
# Check CLI installed
jira --version # Expects: 1.0.0
Config location: ~/utils/atlassian/.env
ATLASSIAN_CLOUD_ID=your-cloud-id
[email protected]:API_TOKEN
ATLASSIAN_SITE_URL=https://your-site.atlassian.net
Get API token from: https://id.atlassian.com/manage-profile/security/api-tokens
User wants to...
├── View issue details
│ └── jira issues read <ISSUE-KEY>
├── List recent issues
│ └── jira issues list [--limit N] [--project KEY]
├── Search issues
│ └── jira issues search "query" [--project KEY]
├── Create new issue
│ └── jira issues create "Title" --project KEY [options]
├── Update existing issue
│ └── jira issues update <ISSUE-KEY> [--status|--assignee|--priority]
├── Fetch complete hierarchy
│ └── jira issues fetch <ISSUE-KEY> --output ./spec
└── Get available transitions
└── jira issues transitions <ISSUE-KEY>
User wants to...
├── List projects
│ └── jira projects list
└── List users
└── jira users list [--query NAME]
├── Add comment
│ └── jira comments create <ISSUE-KEY> --body "Comment text"
└── List comments
└── jira comments list <ISSUE-KEY>
| Operation | Command | Example |
|---|---|---|
| Read | jira issues read <KEY> | jira issues read VA-2228 |
| List | jira issues list | jira issues list --limit 10 --project VA |
| Search | jira issues search "query" | jira issues search "auth bug" |
| Create | jira issues create "Title" | jira issues create "Fix login" --project VA --type Bug |
| Update | jira issues update <KEY> | jira issues update VA-123 --status "In Review" |
| Fetch | jira issues fetch <KEY> | jira issues fetch VA-123 --output ./spec |
jira issues create "Title" \
--project VA \
--type Story \
--description "Detailed description" \
--assignee "account-id" \
--priority High \
--labels "Bug,Critical" \
--parent VA-100
Issue types: Epic, Story, Task, Bug, Sub-task Priority values: Highest, High, Medium, Low, Lowest
jira issues update VA-123 \
--status "In Review" \
--assignee "account-id" \
--priority High \
--labels "Bug,P1" \
--summary "New title"
# Fetch epic with ALL children + linked Confluence pages
jira issues fetch VA-2522 --output ./spec
# Output structure:
# ./spec/
# ├── jira/
# │ ├── VA-2522.json
# │ ├── VA-2522.md
# │ ├── VA-2228.json (child)
# │ └── ...
# ├── confluence/
# │ ├── 12345678.json
# │ └── ...
# └── summary.json
When to use fetch:
# Projects
jira projects list
# Users
jira users list
jira users list --query "john"
# Add comment
jira comments create VA-123 --body "This is a comment"
# List comments
jira comments list VA-123
Issue Operations:
- "Create a Jira issue for..."
- "Open a ticket in Jira..."
- "Log this as a Jira bug..."
- "Check Jira issue VA-123"
- "What's the status of VA-123?"
- "Update VA-123 to..."
- "Move VA-123 to In Review"
- "Assign VA-123 to..."
- "Search Jira for..."
- "Find issues about..."
Fetch Operations (comprehensive):
- "Fetch VA-2228"
- "Pull down VA-2522"
- "Get complete data for VA-2228"
- "Implement from VA-2228"
- "Get requirements for VA-2228"
Metadata:
- "List Jira projects"
- "Who can I assign this to?"
# Jira issue ID pattern
[A-Z]{2,10}-\d+
# Examples: VA-123, DEV-456, BACKEND-789
User: "Create a Jira issue for the login timeout bug"
Steps:
1. Parse request: title=login timeout bug
2. Execute: jira issues create "Login timeout bug" --project VA --type Bug
3. Return: Issue key and details from JSON
User: "What's the status of VA-123?"
Steps:
1. Parse issue ID: VA-123
2. Execute: jira issues read VA-123
3. Return: Issue title, state, assignee, priority from JSON
User: "Move VA-123 to In Review and assign to John"
Steps:
1. Get users: jira users list --query john
2. Find John's account ID from JSON
3. Update: jira issues update VA-123 --status "In Review" --assignee john-account-id
User: "Implement VA-2522"
Steps:
1. Check if reference exists: ls ./spec/jira/VA-2522.json
2. If not: jira issues fetch VA-2522 --output ./spec
3. Read requirements from ./spec/jira/*.md
4. Begin implementation
5. Update progress: jira issues update VA-2228 --status "In Progress"
| Error | Cause | Resolution |
|---|---|---|
command not found: jira | CLI not installed | cd ~/utils/atlassian && npm link |
Missing ATLASSIAN_AUTH_TOKEN | No credentials | Configure ~/utils/atlassian/.env |
Authentication failed | Invalid token | Regenerate API token |
Resource not found | Invalid issue key | Verify issue exists |
Status not available | Invalid transition | Run jira issues transitions VA-123 to see options |
Rate limited | Too many requests | CLI auto-retries with backoff |
All commands output JSON. Parse with jq:
# Get issue title
jira issues read VA-123 | jq -r '.summary'
# Get issue status
jira issues read VA-123 | jq -r '.status'
# List issue keys and titles
jira issues list --limit 10 | jq -r '.[] | "\(.key): \(.summary)"'
# Get created issue key
jira issues create "Title" --project VA | jq -r '.key'
| Need | Use read | Use fetch |
|---|---|---|
| Quick status check | Yes | No |
| Get single issue | Yes | Overkill |
| Get issue + ALL children | No | Yes |
| Get linked Confluence | No | Yes (automatic) |
| Offline reference | No | Yes |
| Implementation context | No | Yes |
| Real-time current data | Yes | Snapshot |
jira CLIHandles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...
Comprehensive guides and best practices for Neon Serverless Postgres, covering setup, connection methods, authentication, and platform APIs.
Guide for setting up and using Firebase Authentication. Use this skill when the user's app requires user sign-in, user management, or secure data access using auth rules.
A skill to evaluate how secure Firestore security rules are. Use this when Firestore security rules are updated to ensure that the generated rules are extremely secure and robust.
Official skill for integrating Firebase AI Logic (Gemini API) into web applications. Covers setup, multimodal inference, structured output, and security.
Complete Better Auth server and client setup with database adapters, session management, plugins, and security configuration.
Deploy and manage projects on Vercel using token-based authentication. Use when working with Vercel CLI using access tokens rather than interactive login — e.g. "deploy to vercel", "set up vercel", "add environment variables to vercel".
Complete Cloudflare platform integration with decision trees for compute, storage, AI, networking, security, and infrastructure-as-code.
Run Azure compliance and security audits with azqr plus Key Vault expiration checks. Covers best-practice assessment, resource review, policy/compliance validation, and security posture checks. WHEN: compliance scan, security audit, BEFORE running azqr (compliance cli tool), Azure best practices, Key Vault expiration check, expired certificates, expiring secrets, orphaned resources, compliance assessment.
Send, read, and manage Gmail messages, drafts, labels, and account settings.
Comprehensive website auditing across 230+ rules in 21 categories including SEO, performance, security, and accessibility.
Shared authentication, CLI syntax, and output formatting patterns for gws Google Workspace commands.
Discover your celebrity doppelgänger with StarByFace!
GeoSpy: Pricing, Features, FAQs, and Alternatives for AI Teams
Detect AI-generated voices to protect against audio fraud.
Ensure Your Content's Originality with AI Plagiarism Checker
Upscale images by 400% without quality loss
Protect your social media from copyright disputes
Accurately Detect AI-Generated Content with TheChecker.AI
Chrome extension that detects and flags AI-generated content