Results for “data”

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

Executes MySQL database development and review tasks based on user-provided rules, covering naming constraints, index design, and data archiving for large datasets.

Provides MariaDB-specific syntax and behavior for CREATE, ALTER, and DROP DATABASE statements, including OR REPLACE vs IF NOT EXISTS, charset and collation defaults, and the absence of RENAME DATABASE.

Designs normalized database schemas, creates indexes, writes efficient queries, and manages transactions and data integrity.

Guides database design, implementation, optimization, migration, pipeline development, and operations across SQL and NoSQL platforms.

Guides database design and operations to avoid common scaling, reliability, and data integrity pitfalls.

Guides database design, implementation, optimization, migration, pipeline development, quality, and operations across SQL and NoSQL platforms.

Guides database design, implementation, optimization, migration, pipeline development, quality, and operations across SQL and NoSQL platforms.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Write and run analytical SQL queries against Redpanda SQL (Oxla), a distributed PostgreSQL-wire-compatible columnar database, including data loading, external sources, and type handling.

Create and manage ODB databases, connect to external databases, and automate forms, reports, and data operations with LibreOffice Base.

Generates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations, producing DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems.

Streams change data capture events from a TigerBeetle financial transactions database into Redpanda or Kafka using the tigerbeetle_cdc input, with checkpointing, filtering, and routing guidance.

Guides scaling decisions for Qdrant vector databases based on data volume, query throughput, latency, or query volume.

Teaches standard SQL for creating, managing, and querying relational databases, covering DDL, DML, DQL, DCL, joins, subqueries, and best practices.

Design reliable, scalable, and maintainable data systems by applying principles from storage engines, replication, partitioning, transactions, and consistency models.

Search, query, inspect, create, and import data into Weaviate vector database collections using official scripts and references.

Create, manage, and automate LibreOffice Base databases, including forms, reports, and data operations.

Generate production-ready Dataverse SDK solutions with architecture recommendations, data models, and implementation code for common business use cases.

Provides expert guidance on modern SQL, cloud-native databases, and query optimization, covering performance tuning, data modeling, and hybrid analytical systems.

Provides expert guidance on modern SQL, cloud-native databases, query optimization, performance tuning, and data modeling for OLTP/OLAP workloads.

Execute KQL queries and manage Azure Data Explorer resources for fast, scalable big data analytics on log, telemetry, and time series data.

Generate XML configuration files and execute SSMA Console commands for Oracle to SQL Server database migration, including schema conversion and data migration.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Creates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations, analyzing a project to identify repositories, DAOs, and service layers that interact with the database, then producing a structured testing plan.

Understand and query the NPSP data model, including namespace prefixes, GAU allocations, recurring donations, relationships, and affiliations.

Guides scaling decisions for Qdrant vector databases when data volume exceeds single-node capacity, covering tenant scaling, time window rotation, vertical scaling, and horizontal sharding.

Manages Xata serverless databases via the xata CLI and REST API, covering discovery of workspaces, databases, branches, tables, schema, migrations, and record counts with read-only operations.

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

Provides a lightweight local SQLite database access layer for AI agents via an MCP server, with installation and usage guidance.