sql-server
Use SQL Server for enterprise relational data storage with advanced features, high availability, and Windows integration.
Use SQL Server for enterprise relational data storage with advanced features, high availability, and Windows integration.
Data modeling conventions including Arrow-based columnar interchange, DuckDB/DuckLake lakehouse patterns, SQLMesh transformations, and scientific data contracts. Load when designing database structures, data pipelines, cross-language analytics, or data relationships.
When the user wants to optimize inventory across multiple network locations, implement multi-echelon inventory policies, or coordinate stock levels between warehouses and distribution centers. Also use when the user mentions "network inventory optimization," "multi-stage inventory," "supply chain network," "echelon stock," "installation stock," "base stock policies," "guaranteed service model," "distribution requirements planning (DRP)," or "serial/arborescent/general network structures." For single-location inventory, see inventory-optimization. For routing with inventory, see inventory-routing-problem.
When the user wants to jointly optimize inventory and routing decisions, implement vendor-managed inventory (VMI) systems, or coordinate replenishment and delivery logistics. Also use when the user mentions "IRP," "inventory routing," "vendor-managed inventory," "VMI optimization," "integrated inventory and transportation," "delivery scheduling with inventory," "maritime inventory routing," "petrol station replenishment," or "coordinated inventory-distribution." For pure routing, see vehicle-routing-problem or route-optimization. For pure inventory, see inventory-optimization or multi-echelon-inventory.
When the user wants to solve single-period inventory problems, optimize stocking levels for perishable goods, or make one-time purchase decisions under demand uncertainty. Also use when the user mentions "newsvendor model," "newsboy problem," "single-period inventory," "perishable inventory," "overage and underage costs," "critical fractile," "fashion goods inventory," "seasonal products," "service level optimization," or "demand distribution matching." For multi-period problems, see dynamic-lot-sizing or stochastic-inventory-models.
When the user wants to optimize hospitality purchasing, manage hotel/restaurant suppliers, or improve procurement processes. Also use when the user mentions "hotel procurement," "restaurant purchasing," "hospitality sourcing," "F&B procurement," "hotel supplier management," "group purchasing organization," "contract negotiation," or "hospitality spend management." For hotel operations, see hotel-inventory-management. For cruise operations, see cruise-supply-chain.
When the user wants to optimize inventory levels, calculate safety stock, determine reorder points, or minimize inventory costs. Also use when the user mentions "inventory management," "safety stock," "EOQ," "reorder point," "service level," "stockout prevention," "ABC analysis," "inventory turns," or "working capital reduction." For warehouse slotting, see warehouse-slotting-optimization. For multi-echelon systems, see multi-echelon-inventory.
When the user wants to optimize omnichannel fulfillment, manage buy-online-pickup-in-store (BOPIS), ship-from-store, or multi-channel inventory. Also use when the user mentions "omnichannel," "BOPIS," "click and collect," "ship from store," "endless aisle," "unified commerce," "store fulfillment," or "buy online return in store." For pure e-commerce, see ecommerce-fulfillment. For last-mile delivery, see last-mile-delivery.
When the user wants to optimize hospital supply chain operations, manage medical materials, optimize PAR levels, or improve hospital inventory management. Also use when the user mentions "hospital supply chain," "materials management," "PAR levels," "OR inventory," "clinical logistics," "hospital distribution," "medical supplies," "stockroom management," "two-bin system," "floor stock," or "hospital warehousing." For pharmacy-specific operations, see pharmacy-supply-chain. For medical device distribution, see medical-device-distribution.
When the user wants to calculate optimal order quantities, minimize total inventory costs using EOQ models, or determine the economic lot size. Also use when the user mentions "EOQ," "Wilson formula," "economic lot size," "order quantity optimization," "production batch size," "quantity discounts," "EPQ" (Economic Production Quantity), "backorder models," or "reorder point calculations." For multi-echelon systems, see multi-echelon-inventory. For stochastic models, see stochastic-inventory-models.
When the user wants to solve lot-sizing problems with time-varying costs or demand, handle non-stationary inventory systems, or optimize replenishment with changing parameters over time. Also use when the user mentions "time-varying lot sizing," "finite horizon lot sizing," "dynamic EOQ," "price changes over time," "seasonal lot sizing," "Wagner-Whitin with time-varying costs," or "rolling horizon planning." For stationary systems, see economic-order-quantity or lot-sizing-problems. For stochastic demand, see stochastic-inventory-models.
When the user wants to optimize e-commerce fulfillment, online order processing, or direct-to-consumer logistics. Also use when the user mentions "e-commerce fulfillment," "online orders," "DTC fulfillment," "pick-pack-ship," "3PL," "fulfillment center," "order accuracy," "shipping optimization," or "returns processing." For omnichannel (stores + online), see omnichannel-fulfillment. For last-mile delivery, see last-mile-delivery.
EventCatalog tooling for schema documentation and event catalog management. Load when documenting events, commands, or domain schemas.
When the user wants to optimize cruise ship supply chains, manage ship provisioning, or improve maritime operations. Also use when the user mentions "cruise logistics," "ship provisioning," "maritime supply chain," "port operations," "cruise inventory," "galley management," "ship chandling," or "cruise procurement." For hotel operations, see hotel-inventory-management. For hospitality procurement, see hospitality-procurement.
When the user wants to optimize production or order lot sizes over multiple periods, solve multi-period inventory planning problems, or determine when and how much to order/produce with time-varying demand. Also use when the user mentions "lot sizing," "lot-for-lot," "fixed order quantity," "POQ" (periodic order quantity), "part-period balancing," "Silver-Meal heuristic," "Wagner-Whitin algorithm," "least unit cost," "lot sizing with capacity constraints," or "multi-item lot sizing." For single-period problems, see newsvendor-problem. For time-varying lot sizing, see dynamic-lot-sizing.
Inventory management for e-commerce: WMS integration (warehouse management systems), dropshipping, 3PL (ShipBob, Flexport), demand forecasting, lot/batch tracking, inventory valuation (FIFO/LIFO/ weighted average), cycle counting, stock tracking (available, reserved, committed), multi-location inventory, backorder handling, reservation patterns, stock alerts, and inventory sync across channels.
Product catalog design for e-commerce: headless platforms (Shopify, Medusa, Saleor, commercetools, Vendure), PIM integration (Akeneo, Pimcore, Salsify), data modeling (products, variants, attributes, categories, collections), GS1/GTIN barcodes, configurable/bundled products, dynamic pricing, reviews and ratings (Bazaarvoice, Yotpo), feed syndication (Google Shopping, Facebook Catalog), schema.org Product markup, tax calculation (Avalara, TaxJar), multi-language/localization, catalog search indexing, and image/media management.
Manage the WealthWise Docker/Podman Compose development environment. Triggers when asked to "start Docker", "start Podman", "bring up the containers", "stop Docker", "show Docker logs", or "restart the dev environment". Does NOT trigger implicitly.
When the user wants to optimize retail store replenishment, calculate reorder points for stores, or manage continuous replenishment. Also use when the user mentions "store replenishment," "auto-replenishment," "min-max inventory," "store orders," "DC to store," "continuous replenishment," or "vendor-managed inventory (VMI)." For initial allocation, see retail-allocation. For DC operations, see warehouse-design.