Skills tagged "sql" (180)

🛡️ Supabase Postgres Best Practices

This skill helps optimize Postgres queries, schemas, and configs with Supabase best practices to boost performance and security.

databasesqlperformancesecurity

4.4k

🛡️ Postgres Patterns

This skill helps you optimize PostgreSQL queries, schemas, and security using best practices from Supabase, boosting performance and reliability.

databasesqlperformancesecurity

190

📋 Go Database

This skill helps you perform type-safe Encore Go database operations with queries, migrations, and transactions to ensure reliability.

databasesqlbackendmigration

78

🛡️ Database

This skill helps you manage Encore database operations, including queries, migrations, and Drizzle ORM integration for secure, efficient data access.

databasesqlbackendmigration

54

📋 Go Infrastructure

This skill helps you declare Encore Go infrastructure at package level, simplifying local and production provisioning across databases, pub/sub, and storage.

infradevopsclouddatabase

53

🐛 Drizzle

This skill helps you design and migrate PostgreSQL schemas with Drizzle ORM, ensuring type-safe, scalable database models and reliable migrations.

databasesqlmigrationbackend

49

🧪 Async Io Model

This skill enforces cooperative IO patterns in core Rust to reliably manage asynchronous operations with explicit state machines for correctness and

databasesqlbackenddata

45

📋 Databases

This skill helps you design and optimize MongoDB and PostgreSQL schemas, queries, and migrations for reliable, scalable data management.

databasesqldatabackend

38

⚙️ Alembic

This skill guides you through Alembic database migrations for customer support systems, ensuring minimal downtime, data integrity, and safe production

databasemigrationsqldata

25

📋 Spring Data Jpa

This skill helps you implement Spring Data JPA persistence layers with repositories, queries, pagination, auditing, relationships, and multi-database

javaspringdatabasedata

24

🛡️ Sqlite

This skill helps you build secure SQLite database operations with parameterized queries, migrations, and FTS5 support for desktop apps.

databasesqlsecurityperformance

20

📝 Documentation Expert

This skill helps you improve documentation quality and user experience by analyzing structure, navigation, and readability and proposing actionable

docscontentuxaccessibility

17

📋 Geospatial Postgis Patterns

This skill helps implement geofences, distance calculations, and real-time tracking using PostGIS to power location-based features.

databasesqldataanalytics

12

🐛 Db Migrations Schema Changes

This skill guides managing Alembic migrations and schema changes for letta-cloud core, enabling safe Postgres or SQLite transitions and upgrades.

databasemigrationbackendsql

6

⚙️ Docs

This skill enables rapid multi-agent orchestration with MCP-B, AMUM-QCI-ETHIC, and DuckDB/SurrealDB pipelines for compliant, visual workflow automation.

aiautomationdatabasesql

5

🐛 Massgen Log Analyzer

This skill analyzes MassGen experiments and logs, generates ANALYSIS_REPORT.md, and guides performance debugging and logging improvements with structured

automationdebugginganalyticsobservability

4

🛡️ Pr Workflow

This skill synthesizes PR workflow guidelines for commits, PRs, CI, security, and dependencies to help teams maintain clean history and focused changes.

gitci-cdcode-reviewtesting

4

⚙️ Data Analyst

This skill helps transform raw data into actionable insights through cleaning, analysis, visualization, reporting, and predictive modeling.

dataanalyticssqldatabase

3

📋 Database Schema Designer

This skill guides you through designing scalable SQL and NoSQL schemas, optimizing normalization, indexing, migrations, and performance for maintainable data

databasesqldataperformance

3

✨ Lovable

This skill helps you manage Lovable.dev projects by guiding backend deployments, migrations, and edge functions through Lovable prompts.

cloudbackenddevopsdatabase

3

🐛 Migrating Dbt Core To Fusion

This skill guides migrating dbt projects from Core to Fusion, handling deprecations and using dbtf commands to ensure zero compile errors.

datasqlautomationdebugging

3

🧪 Adding Dbt Unit Test

This skill guides you in creating robust dbt unit tests to validate model logic before production, ensuring reliability and preventing regressions.

databasesqltestingunit-tests

2

⚙️ Atelier Typescript Drizzle Orm

This skill helps you design and query SQL with Drizzle ORM in TypeScript, enabling type-safe schemas, relations, migrations, and multi-database support.

databasesqltypescriptjavascript

2

📋 Business Intelligence

This skill helps you master enterprise BI tools to build scalable analytics, dashboards, and self-service reporting across organizations.

dataanalyticsdatabasesql

2

📋 Busirocket Tauri

This skill standardizes Tauri desktop app setup, guiding command creation, invoke handler registration, and structured Rust and SQL layouts for maintainability.

backendfullstackdevopssql

2

⚙️ Code Style

This skill enforces Grey Haven coding standards for TypeScript, Python, and project configs, guiding formatting, naming, and multi-tenant patterns across

pythonfastapilintingformatting

2

📋 Data

This skill helps you design and optimize data pipelines and warehouses using SQL, dbt, Spark, and orchestrators to boost analytics.

datasqlanalyticscloud

2

📋 Data Module

This skill integrates async SQLAlchemy data access with request-scoped sessions and pool management to simplify robust database operations.

databasesqldatabackend

2

📋 Database Implementation

This skill designs and validates database schemas, migrations, and query optimization, guiding you from design to rollback with Flyway and Exposed.

databasesqlmigrationbackend

2

🛡️ Database Reviewer

This skill reviews PostgreSQL queries, schemas, security, and performance, applying Supabase best practices to optimize, secure, and scale databases.

databasesqlsecurityperformance

2

🔍 Duckdb Sql

This skill generates DuckDB SQL queries from user questions, validating against asset schemas and producing ready-to-run in-memory queries for review.

sqldatabasedataanalytics

2

📋 Epic Database

This skill helps you design Prisma schemas, migrations, and SQLite with LiteFS for Epic Stack, focusing on efficient queries and multi-region readiness.

prismadatabasesqlperformance

2

📋 Job Description Analyzer

This skill analyzes a job posting, computes your match score, identifies gaps, and crafts resume and cover letter strategies to maximize applications.

productanalyticsdatasql

2

🧪 Microsoft Extensions Configuration

This skill helps .NET developers implement robust configuration binding, validation, and monitoring using Microsoft.Extensions.Options patterns for reliable

backendapisqldebugging

2

🐛 Mongodb Expert

This skill helps you optimize MongoDB schema, indexing, aggregation, and sharding strategies to improve NoSQL performance and design.

databaseperformancedatadebugging

2

📝 Oceanbase Examples

This skill guides creating OceanBase SQL examples with clear structure, meaningful names, and separate results to improve documentation clarity and realism.

databasesqldatawriting

2

📋 Oceanbase Sql Optimization

This skill optimizes OceanBase SQL by guiding query writing, index design, and plan analysis for MySQL and Oracle modes.

databasesqlperformancemonitoring

2

🛡️ Osquery Helper

This skill helps you write, validate, and troubleshoot osquery queries against platform schemas to improve accuracy and performance.

pythonsqlsecuritydata

2

🐛 Performance Optimization

This skill helps optimize Rails performance by detecting N+1 queries, indexing gaps, and memory issues to speed up responses.

performancedebuggingdatabasesql

2

🧪 Postgis Knowledge Patch

This skill helps you craft and optimize PostGIS 3.5+ queries by applying latest function changes, topology, and raster enhancements across spatial analyses.

sqldatabaseanalyticsperformance

2

📋 Postgres Hybrid Text Search

This skill enables hybrid text search in PostgreSQL by combining BM25 keyword search with semantic vectors using RRF for improved relevance.

databasesqldataanalytics

2

🎨 Report Generation

This skill generates comprehensive data analysis HTML reports by querying data, performing deep cause analysis, and delivering visualizations and insights.

dataanalyticssqldatabase

2

🛡️ Scaffolding Fastapi Dapr

This skill helps you scaffold production-grade FastAPI backends with SQLModel, Dapr, and JWT authentication for scalable microservices.

backendapisqldatabase

2

🛡️ Security

This skill helps you implement database security covering access control, encryption, and audit logging to protect data and meet compliance.

securitydatabasesqldata

2

🧪 Test Json Sql Query Web

This skill helps you validate and explore JSON SQL primitives with search-web output by testing project, pluck, filter-structured, and sort operations.

testingdatasqlpython

2

📋 Agents Sdk

This skill helps you build persistent, stateful AI agents on Cloudflare Workers, enabling scheduling, RPC, and streaming chat with Code Mode benefits.

aicloudbackendapi

🐛 Altinity Expert Clickhouse Audit

This skill performs a comprehensive ClickHouse diagnostic by orchestrating expert modules to reveal performance bottlenecks and actionable improvements.

databasesqldataperformance

🐛 Altinity Expert Clickhouse Connection

This skill helps validate ClickHouse connections and prepare MCP or client queries for diagnostics and analysis.

databasesqldataanalytics

🐛 Altinity Expert Clickhouse Dictionaries

This skill analyzes ClickHouse external dictionaries including configuration, memory usage, reload status, and performance to diagnose issues and optimize

databasesqldataanalytics

🛡️ Altinity Expert Clickhouse Grants

This skill diagnoses and resolves ClickHouse grant and authentication errors after upgrades, guiding minimal grants and post-upgrade compatibility checks for

databasesqlsecuritydebugging

📋 Altinity Expert Clickhouse Index Analysis

This skill analyzes ClickHouse index usage and suggests ORDER BY and projection improvements to align with query patterns and reduce scans.

databasesqldataanalytics

📋 Altinity Expert Clickhouse Kafka

This skill diagnoses ClickHouse Kafka engine health and consumer performance to reduce lag and prevent thread starvation.

databasesqldataobservability

📋 Altinity Expert Clickhouse Logs

This skill analyzes ClickHouse system logs health, TTL settings, disk usage, freshness, and cleanup to optimize retention and RCA readiness.

databasesqldataanalytics

🐛 Altinity Expert Clickhouse Memory

This skill helps diagnose ClickHouse RAM usage, OOM risks, and memory pressure, guiding you to optimize queries and configurations.

databasesqldatadebugging

🐛 Altinity Expert Clickhouse Part Log

This skill analyzes ClickHouse system.part_log to diagnose issues from high part churn, mutations, and slow merges, guiding targeted remediation.

databasesqldataanalytics

🐛 Altinity Expert Clickhouse Schema

This skill analyzes ClickHouse table designs, partitions, ORDER BY keys, and materialized views to identify anti-patterns and optimization opportunities.

databasesqldataperformance

📋 Answering Natural Language Questions With Dbt

This skill answers natural language business questions by querying dbt semantic layer, then explores models or manifests if needed to provide an accurate

aidatasqlanalytics

📋 Atelier Python Sqlalchemy

This skill helps you implement robust Python database access with SQLAlchemy ORM patterns, including models, sessions, queries, upserts, and JSON columns.

pythondatabasesqlbackend

⚙️ Ats Skill

This skill streamlines task orchestration by connecting to the ATS backend to create, claim, complete, and monitor tasks in real time.

backendapisqldatabase

🧪 Backend Developer

This skill assists backend development and debugging with NestJS, TypeScript, and PostgreSQL by guiding code structure, tests, and performance improvements.

nestjstypescriptdatabasesql