Results for “schemas”

Design PostgreSQL schemas with best practices for data types, indexing, constraints, and performance patterns.

Build Cloudflare D1 schemas and queries with Drizzle ORM, including migrations, relations, and batch operations.

Write, review, debug, test, and optimize Python Polars code with version-grounded object types, schemas, and execution boundaries.

Design DynamoDB table schemas, write queries, configure indexes, manage capacity, and troubleshoot performance issues using AWS CLI and boto3 examples.

Design schemas, write TypeScript functions, and manage real-time subscriptions, auth, file storage, scheduling, and deployment for Convex backends.

Design schemas, write TypeScript functions, and manage real-time data, auth, storage, scheduling, and deployment for Convex backends.

Creates executable Polars dataframe contracts using Pandera's Polars backend for runtime validation of schemas, columns, and checks.

Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.

Write, review, debug, test, or optimize Python code using PyArrow arrays, schemas, tables, compute kernels, datasets, Parquet, and Arrow IPC.

Design database schemas, plan data migrations, optimize queries, and model data relationships using expert analysis and automated tools.

Design schemas, write TypeScript functions, set up real-time subscriptions, authentication, file storage, scheduling, and deployment for Convex reactive backend projects.

Automate Snowflake data warehouse operations: list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.

Optimize SQL queries, design database schemas, and tune performance across cloud-native and hybrid OLTP/OLAP environments.

Use when designing PostgreSQL tables, enums, relationships, migrations, storage metadata, or tenant-aware schema structures for a Supabase-backed app. Trigger on requests about Supabase schema planning or SQL-first data design.

Provides production patterns and non-obvious traps for Prisma ORM in TypeScript backends, covering schema design, query optimization, transactions, pagination, and common pitfalls.

Define and enforce data schemas and quality checks using pandera, Great Expectations, or manual assertions, with clear error handling and documentation.

Provides safe, reversible database schema change patterns for PostgreSQL, MySQL, and common ORMs, with guidance on zero-downtime deployments, rollbacks, and migration tooling.

Generates a comprehensive, editable schema reference file for a data warehouse, including table metadata, row counts, and codebase context, to enable instant concept-to-table lookups.

Supabase administration, RLS policies, migrations, and schema design. Use for database architecture, Row Level Security, performance tuning, auth integration. Activate on "Supabase", "RLS", "migration", "policy", "schema", "auth.uid()". NOT for Supabase Auth UI configuration (use dashboard), edge functions (use cloudflare-worker-dev), or general SQL without Supabase context.

Manages SurrealDB schemas as desired-state .surql files, with sync for disposable databases and reviewed rollouts for shared or production environments, plus seeding and declarative testing.

Quick reference for PostgreSQL best practices covering indexing, schema design, query optimization, and security defaults.

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 optimizing application performance.

Supabase-first database schema design for Nick's app stack. Generate production-ready Postgres schemas, Supabase SQL migrations, RLS policies, TypeScript types, seed data, role-aware access patterns, and schema checklists from plain English requirements. Use when starting any new project database, designing or reviewing schemas, adding tables, planning migrations, or turning product requirements into Supabase-ready data models. Bias toward product-led schema design, MVP discipline, core-workflow-first modeling, and avoiding premature table/role sprawl.

Production patterns and non-obvious traps for Prisma ORM in TypeScript backends, covering schema design, query optimization, transactions, pagination, and serverless connection handling.

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues using execution plan analysis, indexing strategies, and set-based operations.

Design schemas, write TypeScript queries/mutations/actions, and set up real-time subscriptions, auth, file storage, scheduling, and deployment for Convex backends.

Manage Amazon Aurora DSQL clusters, schemas, and migrations with MCP tools and CLI scripts, including multi-tenant patterns and IAM-based authentication.

Clean and preprocess datasets by handling missing values, removing duplicates, correcting types, resolving outliers, and enforcing validation schemas. Use when the user requests data cleaning or provides relevant inputs for this workflow.

Translate natural language into SQL queries, optimize database performance, generate migrations, explore schemas, and work with ORMs across PostgreSQL, MySQL, SQLite, and SQL Server.

Processes STIX 2.1 threat intelligence bundles from TAXII 2.1 servers, normalizing objects into platform-native schemas and routing them to consuming systems.