Files

uroma 5889d3428b Add comprehensive skills, agents, commands collection

- Added 44 external skills from obra/superpowers, ui-ux-pro-max-skill, claude-codex-settings
- Added 8 autonomous agents (commit-creator, pr-creator, pr-reviewer, etc.)
- Added 23 slash commands for Git/GitHub, setup, and plugin development
- Added hooks for code formatting, notifications, and validation
- Added MCP configurations for Azure, GCloud, Supabase, MongoDB, etc.
- Added awesome-openclaw-skills registry (3,002 skills referenced)
- Updated comprehensive README with full documentation

Sources:
- github.com/obra/superpowers (14 skills)
- github.com/nextlevelbuilder/ui-ux-pro-max-skill (1 skill)
- github.com/fcakyon/claude-codex-settings (29 skills, 8 agents, 23 commands)
- github.com/VoltAgent/awesome-openclaw-skills (registry)
- skills.sh (reference)
- buildwithclaude.com (reference)

2026-02-13 10:30:11 +00:00

3.9 KiB

Raw Permalink Blame History

Query Patterns

Filtering

JavaScript:

// Equality
const { data } = await supabase
  .from("users")
  .select("*")
  .eq("status", "active");

// Comparison
const { data } = await supabase
  .from("users")
  .select("*")
  .gte("age", 18)
  .lt("age", 65);

// Pattern matching
const { data } = await supabase
  .from("users")
  .select("*")
  .ilike("name", "%john%");

// IN operator
const { data } = await supabase
  .from("users")
  .select("*")
  .in("role", ["admin", "moderator"]);

// OR conditions
const { data } = await supabase
  .from("posts")
  .select("*")
  .or("status.eq.featured,priority.gte.5");

// NOT
const { data } = await supabase
  .from("users")
  .select("*")
  .not("status", "eq", "banned");

// NULL check
const { data } = await supabase
  .from("users")
  .select("*")
  .is("deleted_at", null);

// Array contains
const { data } = await supabase
  .from("posts")
  .select("*")
  .contains("tags", ["javascript"]);

// Full-text search
const { data } = await supabase
  .from("posts")
  .select("*")
  .textSearch("content", "supabase & database");

Python:

# Equality
response = supabase.table("users").select("*").eq("status", "active").execute()

# Comparison
response = supabase.table("users").select("*").gte("age", 18).lt("age", 65).execute()

# Pattern matching (case-insensitive)
response = supabase.table("users").select("*").ilike("name", "%john%").execute()

# IN operator
response = supabase.table("users").select("*").in_("role", ["admin", "moderator"]).execute()

# OR conditions
response = supabase.table("posts").select("*").or_("status.eq.featured,priority.gte.5").execute()

# NOT
response = supabase.table("users").select("*").neq("status", "banned").execute()

# NULL check
response = supabase.table("users").select("*").is_("deleted_at", "null").execute()

Pagination

Offset-based (simple, less efficient for large datasets):

// JavaScript
const { data } = await supabase
  .from("posts")
  .select("*")
  .order("created_at", { ascending: false })
  .range(0, 9); // rows 0-9 (first 10)

// Next page
const { data } = await supabase
  .from("posts")
  .select("*")
  .order("created_at", { ascending: false })
  .range(10, 19);

# Python
response = supabase.table("posts").select("*").order("created_at", desc=True).range(0, 9).execute()

Cursor-based (efficient for large datasets):

// JavaScript - use last item's id/timestamp as cursor
const { data } = await supabase
  .from("posts")
  .select("*")
  .order("created_at", { ascending: false })
  .lt("created_at", lastTimestamp)
  .limit(10);

# Python
response = (
    supabase.table("posts")
    .select("*")
    .order("created_at", desc=True)
    .lt("created_at", last_timestamp)
    .limit(10)
    .execute()
)

Counting Rows

// JavaScript - exact count
const { count } = await supabase
  .from("users")
  .select("*", { count: "exact", head: true })
  .eq("status", "active");

console.log(`Active users: ${count}`);

# Python
response = supabase.table("users").select("*", count="exact", head=True).eq("status", "active").execute()

print(f"Active users: {response.count}")

Index Recommendations

Add indexes for frequently filtered/sorted columns:

-- Single column index
create index idx_posts_status on posts (status);

-- Composite index for common filter combinations
create index idx_posts_user_status on posts (user_id, status);

-- Partial index for specific conditions
create index idx_active_posts on posts (created_at) where status = 'active';

-- Use index_advisor for recommendations
select * from index_advisor('SELECT * FROM posts WHERE status = ''active'' ORDER BY created_at');

Query Performance Analysis

-- Analyze query execution plan
explain analyze select * from posts where status = 'active' order by created_at limit 10;

3.9 KiB Raw Permalink Blame History