Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
25
3k
8d agoWrite SQL queries from natural language, manage schema, and connect to databases.
135 skills found
Page 1 of 6
Design data models for construction projects. Create entity-relationship diagrams, define schemas, and generate database structures.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Master relational databases with SQL. Schema design, queries, performance, migrations for PostgreSQL, MySQL, SQLite, SQL Server.
Design schemas, write queries, and configure MongoDB for consistency and performance.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Database Designer - POWERFUL Tier Skill
Airtable API integration with managed OAuth. Manage bases, tables, and records. Use this skill when users want to read, create, update, or delete Airtable records, or query data with filter formulas. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
Write efficient PostgreSQL queries and design schemas with proper indexing and patterns.
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Todo list and task management for AI agents. Add, track, and complete tasks with autonomy levels — agents propose work, humans approve. Works in heartbeats, cron, and conversations. Persistent SQLite CLI with structured JSON output.
Fast Apple Mail search via SQLite on macOS. Search emails by subject, sender, date, attachments - results in ~50ms vs 8+ minutes with AppleScript. Use when asked to find, search, or list emails.
Pinecone vector database — manage indexes, upsert vectors, query similarity search, manage namespaces, and track collections via the Pinecone API. Build sema...
Database Schema Designer
Query and index Elasticsearch with proper mappings, analyzers, and search patterns.
Data engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka,...
Track parcels via the 17TRACK API (local SQLite DB, polling + optional webhook ingestion)
Write Oracle SQL and PL/SQL with proper syntax, hints, and performance patterns.
Design and operate databases avoiding common scaling, reliability, and data integrity traps.
Analyze and optimize SQL queries by providing performance analysis, index recommendations, execution plan interpretation, and optimization suggestions.
Avoid common Django mistakes — QuerySet evaluation, N+1 queries, migration conflicts, and ORM traps.
Generate complete fullstack apps with React/Vue/Next frontend, Node/Python backend, PostgreSQL/MongoDB, Docker, CI/CD, auth, REST/GraphQL APIs.
Build type-safe database queries with Drizzle ORM patterns.
Local-first RAG cache: distill docs into structured Markdown, then index/query with Chroma (vector) + ripgrep (keyword).