GitHub
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
☆ 60,480View skill
blockchain sql databases AI Skills
Discover blockchain sql databases skills, compare source repositories and read the instructions for each workflow.
Categories: blockchain sql databases
blockchain sql databases Clear filters
Browse skills
GitHub
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or...
☆ 27,753View skill
GitHub
database-migration
Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations...
☆ 27,752View skill
GitHub
postgresql-table-design
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
☆ 27,751View skill
GitHub
postgres-schema-design
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features
☆ 18,940View skill
GitHub
prisma-expert
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design...
☆ 18,614View skill
GitHub
clickhouse-io
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
☆ 18,614View skill
GitHub
storage-format
SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb
☆ 17,630View skill
GitHub
transaction-correctness
How WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb
☆ 17,630View skill
GitHub
postgresql
PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with PostgreSQL databases, writing SQL, or managing database systems...
☆ 12,819View skill
GitHub
timescaledb
TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time analytics
☆ 12,818View skill
GitHub
query-writing
For writing and executing SQL queries - from simple single-table queries to complex multi-table JOINs and aggregations
☆ 8,916View skill
GitHub
schema-exploration
For discovering and understanding database structure, tables, columns, and relationships
☆ 8,916View skill
GitHub
dsql
Build with Aurora DSQL - manage schemas, execute queries, and handle migrations with DSQL-specific requirements. Use when developing a scalable or distributed database/application or user requests DSQL.
☆ 8,074View skill
GitHub
neon-postgres
Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integration Use when: neon database, serverless postgres, database branching, neon postgres, postgres serverless.
☆ 7,499View skill
GitHub
postgres-query
Run PostgreSQL queries for testing, debugging, and performance analysis. Use when you need to query the database directly, run EXPLAIN ANALYZE, compare query results, or test SQL optimizations. Always uses read...
☆ 7,004View skill
GitHub
query-builder
Convert natural language questions into SQL queries. Activates when users ask data questions in plain English like "show me users who signed up last week" or "find orders over $100".
☆ 4,538View skill
GitHub
schema-designer
Help design database schemas, create tables, and plan data models. Activates when users ask to create tables, design schemas, or model data relationships.
☆ 4,538View skill
GitHub
whodb
Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.
☆ 4,538View skill
GitHub
database-design
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
☆ 4,233View skill
GitHub
sql-injection-testing
This skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "extract database information through injection", "...
☆ 3,287View skill
GitHub
sqlmap-database-penetration-testing
This skill should be used when the user asks to "automate SQL injection testing," "enumerate database structure," "extract database credentials using sqlmap," "dump tables and columns from a vulnerable database...
☆ 3,287View skill
GitHub
database-design
BK-CI 数据库设计规范与表结构指南，涵盖命名规范、字段类型选择、索引设计、分表策略、数据归档。当用户设计数据库表、优化索引、规划分表策略或进行数据库架构设计时使用。
☆ 2,498View skill
GitHub
postgis-skill
PostGIS-focused SQL tips, tricks and gotchas. Use when in need of dealing with geospatial data in Postgres.
☆ 2,035View skill
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.