GitHub
validate-with-database
Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively
☆ 776Voir le skill
Skills IA blockchain sql databases
Découvrez les skills blockchain sql databases, comparez leurs dépôts et consultez leurs instructions.
Catégories: blockchain sql databases
blockchain sql databases Effacer les filtres
Explorer
GitHub
postgresql-syntax-reference
Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features
☆ 776Voir le skill
GitHub
pg-dump-reference
Consult PostgreSQL's pg_dump implementation for guidance on system catalog queries and schema extraction when implementing pgschema features
☆ 776Voir le skill
GitHub
database-schema-designer
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data in...
☆ 776Voir le skill
GitHub
database-migrations
Safe database migration strategies for zero-downtime deployments. Covers backward-compatible changes, data migrations, and rollback procedures.
☆ 756Voir le skill
GitHub
row-level-security
Implement PostgreSQL Row Level Security (RLS) for multi-tenant SaaS applications. Use when building apps where users should only see their own data, or when implementing organization-based data isolation.
☆ 756Voir le skill
GitHub
nop-orm-modeler
专门用于设计、创建、验证和修改Nop平台的ORM模型文件（.orm.xml）
☆ 676Voir le skill
GitHub
moai-platform-supabase
Supabase specialist covering PostgreSQL 16, pgvector, RLS, real-time subscriptions, and Edge Functions. Use when building full-stack apps with Supabase backend.
☆ 659Voir le skill
GitHub
moai-platform-neon
Neon serverless PostgreSQL specialist covering auto-scaling, database branching, PITR, and connection pooling. Use when building serverless apps needing PostgreSQL, implementing preview environments, or optimiz...
☆ 659Voir le skill
GitHub
plain-optimize
Captures and analyzes performance traces to identify slow queries and N+1 problems. Use when analyzing performance or optimizing database queries.
☆ 651Voir le skill
GitHub
sqlite
Expert guidance for SQLite database with better-sqlite3 Node.js driver including database setup, queries, transactions, migrations, performance optimization, and integration with TypeScript. Use this when worki...
☆ 626Voir le skill
GitHub
sqlite-ops
Patterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.
☆ 626Voir le skill
GitHub
sqlite-database-expert
Expert in SQLite embedded database development for Tauri/desktop applications with focus on SQL injection prevention, migrations, FTS search, and secure data handling
☆ 626Voir le skill
GitHub
sqlite-map-parser
Parse SQLite databases into structured JSON data. Use when exploring unknown database schemas, understanding table relationships, and extracting map data as JSON.
☆ 626Voir le skill
GitHub
data-wrangler
Transform and export data using DuckDB SQL. Read CSV/Parquet/JSON/Excel/databases, apply SQL transformations (joins, aggregations, PIVOT/UNPIVOT, sampling), and optionally write results to files. Use when the u...
☆ 621Voir le skill
GitHub
sql-splitter
High-performance CLI for working with SQL dump files: split/merge by table, analyze contents, validate integrity, convert between MySQL/PostgreSQL/SQLite/MSSQL, create FK-safe samples, shard multi-tenant dumps,...
☆ 621Voir le skill
GitHub
sql-optimization
SQL query optimization patterns including EXPLAIN plan analysis, index strategies, query rewriting, and N+1 query prevention. Use when optimizing slow database queries, analyzing query performance, designing in...
☆ 613Voir le skill
GitHub
sql-query-optimizer
Analyzes and optimizes SQL queries using EXPLAIN plans, index recommendations, query rewrites, and performance benchmarking. Use for "query optimization", "slow queries", "database performance", or "EXPLAIN ana...
☆ 613Voir le skill
GitHub
optimizing-queries
Analyzes and optimizes SQL/NoSQL queries for performance. Use when reviewing query performance, optimizing slow queries, analyzing EXPLAIN output, suggesting indexes, identifying N+1 problems, recommending quer...
☆ 613Voir le skill
GitHub
sql-research
Guide for researching SQL syntax and behavior for database backends. Use when you need to research how a SQL function, command, or feature works in a specific database before implementing it in dbplyr.
☆ 504Voir le skill
GitHub
sql-translation
Guide for adding SQL function translations to dbplyr backends. Use when implementing new database-specific R-to-SQL translations for functions like string manipulation, date/time, aggregates, or window function...
☆ 504Voir le skill
GitHub
database-schema
Schema awareness - read before coding, type generation, prevent column errors
☆ 481Voir le skill
GitHub
axiom-sqlitedata
SQLiteData queries, @Table models, Point-Free SQLite, RETURNING clause, FTS5 full-text search, CloudKit sync, CTEs, JSON aggregation, @DatabaseFunction
☆ 456Voir le skill
GitHub
axiom-sqlitedata-ref
SQLiteData advanced patterns, @Selection column groups, single-table inheritance, recursive CTEs, database views, custom aggregates, TableAlias self-joins, JSON/string aggregation
☆ 456Voir le skill
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.