Databases

Document database schemas, ERD diagrams, table relationships, indexes, and constraints. Use when documenting database schema, creating ERD diagrams, or writing table documentation.

Implement database sharding for horizontal scalability. Use when scaling large databases, distributing data across multiple servers, or designing sharded architectures.

Identify security vulnerabilities through SAST, DAST, penetration testing, and dependency scanning. Use for security test, vulnerability scanning, OWASP, SQL injection, XSS, CSRF, and penetration testing.

Manage database migrations and schema versioning. Use when planning migrations, version control, rollback strategies, or data transformations in PostgreSQL and MySQL.

Access OpenCASCADE geometry kernel through Python bindings (pythonocc-core or OCP). Use for B-rep modeling, NURBS surfaces, boolean operations, and STEP/IGES file handling. Foundation for CadQuery and build123d.

Read, write, and manipulate STEP (ISO 10303) CAD files using Python. Use for importing/exporting 3D models, extracting geometry data, and converting between CAD formats. Works with OCP, pythonocc, and cadquery.

BioPython library for computational molecular biology. Use when working with biological sequence data, parsing bioinformatics file formats (FASTA, GenBank, PDB), performing sequence analysis, or accessing biological databases programmatically.

Connect to and query SQL databases, execute queries, and handle database transactions. Use when reading from or writing to databases, performing batch inserts, managing connections, or executing complex SQL queries in data pipelines.

Create parametric 3D CAD models using CadQuery Python library. Use when building mechanical parts, assemblies, or exporting to STEP/STL formats. Supports workplanes, extrusions, chamfers, fillets, and boolean operations.

Query search APIs to find relevant web content and retrieve structured results. Use when searching for web pages, finding articles or documents by topic, or aggregating search results from multiple queries.

Connect to IBM DB2 databases, execute SQL queries, and manage transactions. Use when integrating with DB2 mainframe databases, querying legacy data, or migrating data from DB2 systems.

Exploit padding oracle vulnerabilities in CBC mode encryption. Use this skill when attacking web applications or services that leak information about PKCS7 padding validity.

Balance inventory across warehouse locations for optimal fulfillment. Use this skill when redistributing stock between locations, optimizing inventory positioning, managing regional inventory levels, or planning inventory transfers.

Create 3D CAD models using build123d, a modern Python CAD library with builder pattern. Use for parametric modeling, assemblies, and STEP/STL export. Offers cleaner syntax than CadQuery with context managers.

BLAST (Basic Local Alignment Search Tool) for sequence similarity searches. Use when searching for homologous sequences in databases, identifying protein or nucleotide sequence matches, or performing local BLAST queries.

Access and query the UniProt protein database for sequence data, annotations, and functional information.

Analyze biological pathways using KEGG, Reactome, and other pathway databases.

Interact with Salesforce REST API for CRUD operations on CRM objects. Use when fetching contacts from Salesforce, creating leads, updating accounts, querying with SOQL, or building Salesforce integrations.

Query and mutate data using GraphQL APIs. Use when working with GraphQL endpoints, building complex queries with nested relationships, implementing mutations, or handling GraphQL subscriptions.

Apply Open Source Intelligence gathering techniques for reconnaissance. Use this skill when collecting publicly available information about targets, searching public databases, or aggregating intelligence from multiple open sources.