Results for “database”

Agent fallback for CCSPlayerController_AddedToEntityDatabase (auto-generated, category: vfunc). Locate CCSPlayerController::AddedToEntityDatabase in the CS2 server module via IDA Pro MCP and emit a fresh, minimal-unique artifact. The deterministic preprocessor could not resolve this symbol on the current gamever - your job is the re-sign. Trigger: CCSPlayerController_AddedToEntityDatabase, CCSPlayerController::AddedToEntityDatabase

The English summary is being prepared. Showing the original description.

Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures. Masters SQL/NoSQL/TimeSeries database selection, normalization strategies, migration planning, and performance-first design. Handles both greenfield architectures and re-architecture of existing systems. Use PROACTIVELY for database architecture, technology selection, or data modeling decisions.

The English summary is being prepared. Showing the original description.

Specialized skill for containerized database testing using Testcontainers. Use when testing real database behavior, using SQL Server/PostgreSQL/MySQL containers, testing EF Core/Dapper. Covers container startup, database migrations, test isolation, container sharing. Keywords: testcontainers, container testing, database testing, MsSqlContainer, PostgreSqlContainer, MySqlContainer, EF Core testing, Dapper testing, Testcontainers.MsSql, Testcontainers.PostgreSql, GetConnectionString, IAsyncLifetime, CollectionFixture

The English summary is being prepared. Showing the original description.

Guide PostgreSQL database design and troubleshooting with examples for faster queries, indexes that speed up searches, suitable data types, and row-level access rules. Also covers connection settings and SQL for investigating performance problems.

• Investigating slow PostgreSQL queries
• Choosing indexes and column data types
• Designing row-level access rules

Design and review Prisma database code for TypeScript backends. Use examples for schemas, queries, transactions, pagination, migrations, and connection management to identify common pitfalls in bulk operations and serverless deployments.

• Designing database models and relationships with Prisma
• Reviewing queries and pagination
• Investigating transaction and bulk update problems

Summarize the past 24 hours of Notion document edits, comments, mentions, and database row changes in a Notion-style briefing page. It runs through Orbit's daily scheduler using an authenticated Notion connection and a fixed page structure.

• Reviewing the previous day's Notion document edits
• Checking comments and mentions in a daily briefing
• Reviewing database row changes together

Build advanced AgentDB workflows with database synchronization, multiple databases, and search that combines meaning with attribute filters. Covers similarity measures, diverse search results, and operational patterns for distributed AI applications.

• Sharing stored patterns across multiple AgentDB instances
• Filtering semantic search by date or category
• Separating knowledge and conversation databases

Build advanced AgentDB workflows with database synchronization, multiple databases, and search that combines meaning with attribute filters. Covers similarity measures, diverse search results, and operational patterns for distributed AI applications.

• Sharing stored patterns across multiple AgentDB instances
• Filtering semantic search by date or category
• Separating knowledge and conversation databases

Implement database action handlers for syncable entities in Twenty server internals. It covers create, update, and delete operations, with conversion from universal identifiers to database IDs before each action is executed.

• Implement create, update, and delete handlers for a new entity
• Convert universal relation identifiers into database IDs
• Check runner implementation before the integration step

Retrieve facts from named scientific, regulatory, economic, and other databases through documented APIs. Get results with recorded filters, retrieval dates, and record counts so another person can repeat the lookup and assess its completeness.

• Look up gene or compound records by identifier
• Collect clinical trials matching defined criteria
• Retrieve economic statistics with documented sources

Guide Prisma 8 development by selecting task-specific references for data definitions, queries, migrations that change database structure, runtime setup, debugging, and upgrades. Check package versions and generated contract files before proceeding with implementation.

• Set up Prisma 8 or connect it to an existing database
• Edit data definitions and plan database migrations
• Write queries and configure database connections

Assess database security within an authorized scope by reviewing network exposure, authentication, access permissions, risky features, audit logs, and backup access. Distinguish configuration weaknesses from issues that can be demonstrated through safe validation.

• Reviewing database exposure and TLS settings
• Checking account privileges and sensitive table access
• Assessing dangerous features and configuration weaknesses

Set up Python APIs with FastAPI using organized project templates. Build routes, asynchronous database operations, authentication, and error handling, with examples for sharing dependencies and testing endpoints through a separate test database.

• Set up a new FastAPI project
• Build a Python API with asynchronous database access
• Organize authentication and shared dependencies

Analyzes one .NET project to plan integration tests for an Oracle-to-PostgreSQL migration. Identifies database access methods, prioritizes migration risks, and documents test cases, seed data, and coverage, including empty strings, NULL values, and timezone behavior.

• Identifying database access methods that need integration tests
• Prioritizing tests for Oracle-specific behavior
• Planning checks for empty strings, NULL values, and timezones

Investigate database slowdowns and plan measurable improvements to queries, indexes, caching, and scaling. The skill covers SQL and NoSQL systems, with guidance on monitoring, load testing, migrations, and balancing performance against cost.

• Analyze slow SQL queries and execution plans
• Resolve repeated database calls in APIs
• Plan indexes and caching for high traffic

Guides development with Neon, a managed Postgres database platform, using official documentation. Covers project setup, connection choices, local development, authentication, data APIs, and resource management through command-line tools and programming libraries.

• Set up a Neon project and database connection
• Choose a connection method for serverless or edge functions
• Integrate Neon authentication and data APIs

Create and manage MySQL, PostgreSQL, and SQL Server databases on Google Cloud. Covers instance setup, users, backups, availability, and secure connections, with a PostgreSQL walkthrough and references for application connectors and Terraform configuration.

• Create a PostgreSQL database on Google Cloud
• Manage database users and passwords
• Connect through Cloud SQL Auth Proxy

Create Mermaid diagrams from text to explain software structure, API interactions, workflows, and database relationships. The skill guides diagram selection, syntax, styling, and export, helping keep visual documentation editable and stored alongside code.

• Explaining system architecture with diagrams
• Mapping API requests and responses
• Documenting database table relationships

Build document search and AI retrieval workflows with Chroma, a database for numerical representations of text. Cover document storage, meaning-based search, metadata filters, persistence, and connections to LangChain and LlamaIndex.

• Building document search based on meaning
• Adding document retrieval to AI answers
• Filtering search results by document attributes

Connect a company SQL database, support ticket exports, and documents in cognee, linking shared people, teams, and projects so questions about ownership, decisions, and ongoing work can draw on several sources together.

• Finding owners across company databases, tickets, and documents
• Tracing decisions across multiple company sources
• Checking who is handling a support issue

Plan database, service, and infrastructure migrations with phased steps, compatibility checks, and rollback procedures for returning to the previous system. Define risks and validation checkpoints to guide transitions with minimal disruption to business operations.

• Planning a database schema migration
• Checking API changes for compatibility
• Preparing a phased cloud migration

Review database structures and relationships, identify design issues, and generate relationship diagrams. The skill recommends indexes, which help queries find data efficiently, and prepares migration steps with validation and rollback planning.

• Reviewing table structures and relationships
• Improving indexes for frequent queries
• Planning database changes without downtime

Design and build backend services with API scaffolding, database migrations, authentication reviews, and load testing. Generate route handlers from OpenAPI specifications, identify PostgreSQL optimization opportunities, and compare architecture choices against traffic, data sensitivity, and reliability requirements.

• Generating API route handlers from OpenAPI
• Investigating slow PostgreSQL queries
• Reviewing authentication and input validation

Design n8n automations for incoming events, API connections, database synchronization, AI agents, scheduled tasks, and batch processing. Choose a suitable structure, plan error handling, check connections, test results, and review performance when processing large numbers of items.

• Sending form submissions to Slack
• Generating and emailing scheduled reports
• Synchronizing records between databases