Skills tagged "sql" (180)

🧪 Migrations

This skill helps you manage database schema changes safely with version control, migration tools, and zero-downtime deployment strategies.

databasesqldevopsci-cd

📋 Minimal

This skill helps you sync Stripe data to a Postgres database using stripe-sync-engine, covering setup, migrations, webhooks, backfill, and queries.

backenddatabasesqldata

🧪 Mirrord Db Branching

This skill helps you configure mirrord.json for safe database branching, generating valid configs and explaining copy modes, IAM auth, and branch management.

databasesqldevopsautomation

🛡️ Mssql

This skill executes safe read-only MSSQL queries across multiple databases to explore schemas, analyze data, and check contents without risking writes.

databasesqldataanalytics

📋 Mysql

This skill executes safe read-only MySQL queries across configured databases to explore schemas and analyze data without risking writes.

databasesqlpythondata

🛡️ Mysql Best Practices

This skill helps you apply MySQL best practices for query optimization, security, and schema design to build robust, scalable databases.

databasesqlsecurityperformance

⚙️ Neon Postgres

This skill helps you navigate Neon Serverless Postgres with best practices, setup steps, and tooling guidance for efficient development.

databasebackendcloudtypescript

🎨 Nextjs Expert

This skill helps you diagnose and optimize Next.js App Router issues, hydration, and performance to deliver faster, reliable deployments.

frontendfullstackperformancedebugging

🎨 Nuxt Content

This skill helps you work with Nuxt Content v3 by guiding collections querying rendering and database setup for content-driven apps.

frontendbackenddatasql

📋 Oceanbase Schema Design

This skill helps you design efficient OceanBase schemas for MySQL and Oracle modes, covering tables, partitions, indexes, and table groups to boost performance.

databasesqldataperformance

📝 Oceanbase Sql Doc

This skill helps you write and format OceanBase SQL statement documentation according to official style guidelines, ensuring clear structure and accurate

sqldatadocswriting

🛡️ Oracle Dba Skill

This skill provides expert Oracle Autonomous Database guidance for performance, security, HA/DR, and OCI automation to optimize DBA tasks.

databasesqldevopscloud

🛡️ Pglr

This skill securely queries PostgreSQL databases via pglr, lists tables, and describes schemas without exposing credentials.

databasesqlclisecurity

🧪 Playwright Expert

This skill provides expert Playwright guidance for setting up E2E tests, cross-browser runs, and reliable automation workflows.

testingautomationfrontenddebugging

📋 Postgres Migrations

This skill helps you write safe PostgreSQL migrations that avoid blocking reads and writes by applying vetted, non disruptive patterns.

databasesqlmigrationbackend

⚙️ Postgres Query

This skill executes SQL queries against PostgreSQL containers, auto-detects instances, and supports SELECT, INSERT, UPDATE, and DELETE with safe output.

databasesqlscriptingcli

📋 Postgresql

This skill guides PostgreSQL table design by enforcing 3NF normalization, appropriate data types, indexing strategies, and safe schema evolution.

databasesqldataperformance

📋 Query

This skill helps you query Stripe synced data efficiently from PostgreSQL, optimizing joins, filters, and ORM integration.

sqldatabaseanalyticsbackend

📋 Query Builder

This skill converts natural language questions into SQL queries by analyzing schema, intents, and joins to deliver accurate data results.

databasesqldataanalytics

📋 Query Optimization

This skill analyzes SQL queries, suggests indexing and rewriting techniques to boost performance across databases.

databasesqlperformance

🐛 Query Writing

This skill helps you write and execute SQL queries across simple and complex scenarios, delivering accurate results and clear answers.

sqldataanalyticsdatabase

⚙️ Query Writing

This skill helps you write and run SQL queries, from simple single-table lookups to complex multi-table joins and aggregations.

sqldatabasedataanalytics

🧪 Refactoring Expert

This skill identifies code smells and guides safe, incremental refactoring to improve structure while preserving behavior.

refactorcode-reviewtestingvue

🛡️ Relational Database Tool

This skill enables safe CloudBase Relational Database operations via MCP tools, guiding read, write, and security rule actions without using standard SDKs.

databasesqlsecuritycloud

🧪 Rest Api Expert

This skill helps you design robust REST APIs with proper endpoints, HTTP semantics, versioning, error handling, pagination, and OpenAPI documentation.

apibackendperformancedocs

📋 Schema Designer

This skill helps you design scalable database schemas, create tables, and model relationships with clear DDL explanations.

databasesqldatadesign

🐛 Schema Exploration

This skill helps you explore database schemas, map table relationships, and extract column details and sample data for informed queries.

sqldatabasedataanalytics

⚙️ Schemachange

This skill helps you manage Snowflake schema changes with version-controlled migrations and CI/CD pipelines for safe deployments.

databasedevopsci-cdsql

📋 Server

This skill helps you scaffold and maintain a FastAPI backend in server/ with Async SQLAlchemy, migrations, and AI tooling.

backendapifastapipython

⚙️ Setup

This skill helps you install and configure stripe-sync-engine for syncing Stripe data to PostgreSQL, guiding environment setup and runtime integration.

databasedevopsbackendapi

⚙️ Setup Timescaledb Hypertables

This skill helps you design TimescaleDB hypertables with optimal partitioning, compression, retention, and continuous aggregates to improve time-series

databasesqldataanalytics

🧪 Sf Data

This skill helps you manage Salesforce data efficiently by generating and executing SOQL, DML, and bulk operations with test data and cleanup commands.

datasqlapiautomation

⚙️ Smart Data Query

This skill converts business requirements and a data warehouse catalog into executable, readable SQL across Hive, SparkSQL, and GaussDB.

sqldataanalyticsdatabase

📋 Sql Development

This skill helps you design efficient database schemas, write optimized SQL, and manage data operations following best practices.

databasesqldataperformance

📋 Sql Fundamentals

This skill helps you master SQL fundamentals, enabling efficient data queries, updates, and design patterns across databases.

sqldatabasedatabackend

📋 Sql Queries

This skill writes correct, performant SQL across major dialects, translating and optimizing queries for analytics, dashboards, and data pipelines.

sqldatabaseanalyticsperformance

📋 Sql Standards

This skill enforces Hive and SparkSQL compatible SQL standards, ensuring executability, clear parameterization, and dialect-aware output for data warehouses.

sqldatabasedataanalytics

🛡️ Sqladmin

This skill helps you build and tailor SQLAdmin interfaces for SQLAlchemy models in FastAPI or Starlette apps, including authentication, views, and async

backendapidatabasesql

🐛 Sqlalchemy

This skill provides comprehensive SQLAlchemy guidance to answer core, ORM, and dialect questions, helping you implement and optimize database interactions in

pythonsqldatabasebackend

⚙️ Sqlc

This skill helps you generate type-safe Go code from SQL queries with sqlc across SQLite, PostgreSQL, and MySQL.

sqldatabasebackendautomation

🛡️ Sqlcipher

This skill helps you securely manage encrypted databases with robust key derivation, rotation, and memory protection using SQLCipher.

securitydatabasesqldata

📝 Sqldown

This skill enables bidirectional markdown and SQLite workflows by importing into a dynamic schema and querying with SQL for fast document insights.

databasesqldatacli

🧪 Standards Migration

This skill guides you to create reversible, well-named migrations with zero-downtime deployment strategies and safe data transformations.

migrationdatabasesqldata

🐛 Storage Format

This skill helps you understand and navigate SQLite-like on-disk storage structures, including pages, B-trees, and overflow handling.

databasesqldatadebugging

🛡️ Supabase Audit Rpc

This skill audits Supabase RPC functions for security issues, testing RLS bypass, SQL injection, and exposure risks to deliver actionable findings.

apisecuritydatabasesql

🛡️ Supabase Backend

This skill provides architecture and implementation guidance for Supabase-backed real-time tracking, focusing on database optimization, RLS, edge functions,

backenddatabasesqlsecurity

📋 Surrealdb

This skill generates production-ready SurrealQL queries and schema designs for SurrealDB, enabling robust CRUD, graph relations, authentication, and

databasesqlbackendperformance

🧪 Test Json Sql Semantic Scholar

This skill validates and analyzes JSON SQL primitives using semantic-scholar output to ensure accurate data extraction, filtering, and sorting.

pythonsqldatatesting

🧪 Testing

This skill guides you in writing and running tests across .sqltest and Rust, enabling reliable SQL compatibility and regression coverage.

testingdatabaserustsql

📋 Transactions

This skill helps you implement ACID transactions, manage isolation levels, and handle concurrency in SQL backed applications.

databasesqlbackenddata

🐛 Typedb

This skill helps you write and debug TypeQL queries for TypeDB 3.8+, covering schema, data operations, and complex pattern matching.

databasedatasqldebugging

📝 Typeorm

This skill provides comprehensive TypeORM documentation to answer questions about data sources, entities, relations, migrations, and advanced features.

databasesqldatabackend

🧪 Using Dbt For Analytics Engineering

This skill helps you leverage dbt for analytics engineering by guiding model building, testing, and impact analysis with best practices.

databasesqldataanalytics

⚙️ Vault Search

This skill enables semantic search and SQL-like queries across your Obsidian vault, surfacing related notes and frontmatter metadata.

aiautomationdatabasesql

⚙️ Webhook

This skill helps you implement Stripe webhook endpoints that automatically sync events to PostgreSQL using stripe-sync-engine.

apibackendfullstackdatabase

⚙️ Whodb

This skill helps you manage and explore PostgreSQL, MySQL, MongoDB and more with guided queries and schema discovery.

databasesqldataanalytics

📋 Wprdc

This skill lets you query Pittsburgh regional data center datasets with SQL, enabling fast property lookups, civic insights, and county-wide statistics.

sqldatabasedataanalytics

⚙️ Write Script Mysql

This skill helps you write safe MySQL queries by guiding parameter placeholders, comments, and syntax for clean, maintainable database access.

databasesqlscriptingbackend

🗄️ Database Expert

Schema design, query optimization, migrations, and database architecture

sqlpostgresmysqlschema

🗄️ SQL Expert

Write optimized SQL queries, design schemas, and troubleshoot database performance

sqlpostgresqlmysqlsqlite