Results for “data structures”

Use when you need to apply data-oriented programming best practices in Java — including separating code (behavior) from data structures using records, designing immutable data with pure transformation functions, keeping data flat and denormalized with ID-based references, starting with generic data structures converting to specific types when needed, ensuring data integrity through pure validation functions, and creating flexible generic data access layers. This should trigger for requests such as Improve the code with Data-Oriented Programming; Apply Data-Oriented Programming; Refactor the code with Data-Oriented Programming; Model Java data with records and pure functions; Separate Java behavior from immutable data structures; Validate data integrity with pure Java functions. Part of Plinth Toolkit

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

Clean, combine, summarize, and reshape tabular data with pandas DataFrames, Python's table-like data structures. Produces transformation code and validation checks, including time series processing and memory-conscious approaches for large datasets.

• Fill missing values and correct data types
• Combine tables using multiple matching columns
• Create grouped summaries and pivot tables

Create or improve a company-specific data analysis skill by gathering analysts’ knowledge and examining database structures. Document business terms, metric formulas, table relationships, and common query patterns in reusable reference files.

• Create a data analysis skill for a company
• Document metric formulas and standard exclusions
• Add knowledge about a new business domain

Turn application requirements into an Azure Cosmos DB NoSQL data model. Gather read and write patterns, workload volumes, and relationships, then document container structures, partition keys for distributing data, indexes, and design trade-offs in two Markdown files.

• Designing a data model for a new application
• Choosing how to group and partition related data
• Reviewing database costs for high-volume workloads

Turn plain language requirements into SQL, investigate slow queries, document database structures, and prepare migration templates with rollback plans. Support everyday database development and ORM use, where libraries connect application code to database tables.

• Writing SQL for reports and data retrieval
• Investigating slow queries and repeated database calls
• Preparing schema changes and rollback plans

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

Inspect database connections and table structures configured in DBX, run read-only queries with row and time limits, and generate schema documentation or DBML, a text format for describing database structures.

• Explore tables and columns in a DBX database
• Check data with bounded read-only queries
• Generate database structure documentation

Expert blueprint for data-oriented design using Resource/RefCounted classes (item databases, character stats, reusable data structures). Covers typed arrays, serialization, nested resources, and resource caching. Use when implementing data systems OR inventory/stats/dialogue databases. Keywords Resource, RefCounted, ItemData, CharacterStats, database, serialization, @export, typed arrays.

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

Expert blueprint for data-oriented design using Resource/RefCounted classes (item databases, character stats, reusable data structures). Covers typed arrays, serialization, nested resources, and resource caching. Use when implementing data systems OR inventory/stats/dialogue databases. Keywords Resource, RefCounted, ItemData, CharacterStats, database, serialization, @export, typed arrays.

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

Trace application behavior and explain data structures using compact text tree diagrams. The diagrams connect user actions to real functions, data types, state changes, and the components that render again as a result.

• Tracing what happens after a user action
• Investigating why a component renders again
• Mapping data structures and their consumers

Get documentation-based help with PostgreSQL queries, database design, administration, and performance tuning. The supplied reference also explains connection settings and libpq, PostgreSQL’s C client library, for investigating connection failures and implementing connection handling.

• Writing SQL and planning database structures
• Checking connection strings and parameter settings
• Investigating connection failures with libpq

Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers. Use this skill when creating or modifying database model files, ORM classes, schema definitions, or data model relationships. Apply when working with model files (e.g., models.py, models/, ActiveRecord classes, Prisma schema, Sequelize models), defining table structures, setting up foreign keys and relationships, configuring cascade behaviors, implementing model validations, adding timestamps, or working with database constraints (NOT NULL, UNIQUE, foreign keys). Use for any task involving data integrity enforcement, relationship definitions, or model-level data validation.

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

Designs database schemas with proper normalization, indexing, constraints, and tenant isolation patterns. Use when someone needs to create a new database schema, add multi-tenant support, design row-level security policies, or optimize table structures. Trigger words: database schema, table design, RLS, row-level security, foreign keys, indexes, migrations, ERD, data model, normalization.

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

Algorithms and data structures from first principles through advanced analysis. Covers sorting (bubble, insertion, selection, merge, quick, heap, radix), searching (linear, binary, BFS, DFS, Dijkstra, A*), fundamental data structures (arrays, linked lists, stacks, queues, hash tables, trees, heaps, graphs, tries), complexity analysis (Big-O, Big-Omega, Big-Theta, amortized), recurrence relations, and algorithm design paradigms (divide-and-conquer, greedy, dynamic programming, backtracking). Use when analyzing, selecting, implementing, or comparing algorithms and data structures.

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

Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers. Use this skill when creating or modifying database model files, ORM classes, schema definitions, or data model relationships. Apply when working with model files (e.g., models.py, models/, ActiveRecord classes, Prisma schema, Sequelize models), defining table structures, setting up foreign keys and relationships, configuring cascade behaviors, implementing model validations, adding timestamps, or working with database constraints (NOT NULL, UNIQUE, foreign keys). Use for any task involving data integrity enforcement, relationship definitions, or model-level data validation.

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

Validate and convert crystal and molecular structures, compare symmetry assignments, and build phase diagrams showing relative stability from local calculation data. Preserve sources and parameters while analyzing materials data or planning limited Materials Project queries.

• Validating crystal structures in CIF files
• Comparing symmetry assignments across tolerances
• Converting structure files and checking information loss

Explore SQLite and PostgreSQL databases: list tables, inspect schemas (columns/types/constraints), preview data, generate Mermaid ER diagrams, and run safe read-only queries. Triggered by requests to explore a database, view table structures, describe tables, generate diagrams, or query data, and by keywords like database exploration, schema, ER diagram, or SQL query.

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

Expert-level data structures covering arrays, linked lists, trees, heaps, hash tables, graphs, and advanced structures like segment trees, tries, and union-find.

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

Review JavaScript JSON parsing for malformed input and unexpected data structures. Add error handling and validate parsed data before use, helping prevent failures when reading API responses, browser storage, or user-provided content.

• Reviewing JSON parsing in API response handling
• Handling malformed data from localStorage
• Validating data structures before accessing properties

Process molecular datasets in Python through a simpler interface to RDKit, a chemistry toolkit. Convert and standardize structures, calculate molecular properties, compare and cluster compounds, generate 3D conformations, and visualize results for drug discovery workflows.

• Load and standardize molecular datasets
• Calculate molecular properties and similarities
• Cluster compounds and select diverse subsets

Design MongoDB data structures around how data is accessed, write queries, and build staged data transformations for aggregation. Review indexes and query execution statistics to identify performance issues and choose suitable approaches for related or time-series data.

• Choosing between embedded and referenced data
• Writing search queries and aggregation pipelines
• Reviewing slow queries and index usage

Investigate slow SQL, write complex joins and summaries, and design database structures. Uses execution plans, which show how queries run, to guide index choices and query rewrites, with before-and-after performance measurements.

• Investigate a slow SQL query
• Write complex joins and grouped calculations
• Design tables, keys, and constraints

Golang data structures — slices (internals, capacity growth, preallocation, slices package), maps (internals, hash buckets, maps package), arrays, container/list/heap/ring, strings.Builder vs bytes.Buffer, generic collections, pointers (unsafe.Pointer, weak.Pointer), and copy semantics. Use when choosing or optimizing Go data structures, implementing generic containers, using container/ packages, unsafe or weak pointers, or questioning slice/map internals. Not for applying optimization patterns once profiling has identified a bottleneck (→ See `samber/cc-skills-golang@golang-performance` skill).

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

Query RCSB PDB (200K+ structures) via the public REST + GraphQL APIs with plain `requests` (no SDK). Search by text, attribute, sequence, or 3D structure similarity (Search API); retrieve metadata via GraphQL (Data API); download PDB/mmCIF from files.rcsb.org. For AlphaFold predictions use alphafold-database-access; for protein sequences only use uniprot-protein-database.

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