Free Developer Tools tools
231 templates, calculators, worksheets and reference tables. Each runs in your browser and exports to PDF, Excel, Word or CSV.
Templates and forms
AI Agent ERP Access Request Form Template
A fill-in form that records which ERP roles, objects and limits an AI agent service account needs, with approval signatures.
MCP Server Deployment Runbook Template
A fill-in runbook covering host, secrets, network, health checks, monitoring and rollback for an MCP server in front of an ERP.
WhatsApp Webhook Incident Runbook Template
A fill-in runbook for when WhatsApp messages stop arriving, signatures fail or delivery receipts go missing. Export to PDF or Word.
EDI AS2 Connection Parameters Request Template
A form to exchange AS2 IDs, endpoints, certificates, MDN settings and security options with a trading partner before testing.
Worksheets
MCP Tool Catalog and Risk Worksheet
Register each MCP tool your agent exposes, the ERP object it touches and a computed risk score, then export to Excel.
ERP API Field Mapping Worksheet
Map each ERP API field to the parameter an AI tool exposes, with types, required flags and transform rules, then export to Excel.
Webhook Event Test Case Worksheet
A test plan grid for messaging webhooks: inbound text, status receipts, duplicates, bad signatures and ERP failures. Exports to Excel.
ERP Data Dictionary Worksheet
An editable table to document ERP tables and columns with type, length, null rate, fill rate and owner.
ERP SQL Query Catalog Worksheet
An editable inventory of the queries and reports your team runs, with owner, frequency, runtime and monthly effort.
Scheduled SQL Job Register Worksheet
An editable register of scheduled jobs with daily runtime, dependencies, owners and failure contacts.
SQL Query Tuning Log Worksheet
A tuning log that records the change, before and after runtime and logical reads, and calculates percent improvement.
SQL Query Performance Tuning Log Worksheet
An editable log of slow ERP queries with before and after timings that computes percent improvement and CPU hours saved per day.
Calculators and simulators
NetSuite API Retry Backoff Wait Time Calculator
Plan exponential backoff for NetSuite 429 and concurrency errors: delay per attempt, total wait with and without jitter, and worst case duration.
NetSuite OAuth 2.0 Access Token Refresh Calculator
Work out how often your integrations refresh NetSuite OAuth 2.0 access tokens and how many API calls each token serves.
Acumatica API Request Capacity Calculator
Sizes API traffic from integrations, sync frequency and batch size, then checks headroom against your licensed request limit.
ERP API Rate Limit Calculator for AI Agents
Check whether your AI agents will exceed an ERP API rate limit at peak, and how many agents the limit can support.
MCP Tool Schema Token Cost Calculator
Estimate the tokens and monthly cost of tool definitions sent on each request, and how caching or fewer tools changes it.
MCP Tool Definition Context Token Overhead Calculator
Sizes the context window and input cost eaten by MCP tool schemas before the user says a word, and shows the what-if as you add tools.
ERP API Initial Data Sync Duration Calculator
Computes how many pages, how many hours and how many quota days an initial extract from an ERP REST API will take, with a page-size what-if.
Webhook Retry Backoff Window Calculator
Shows how long an exponential retry policy keeps trying and whether it outlasts your receiver's expected outage.
MCP Server End-to-End Availability Calculator
Multiplies component uptimes in the agent request path and shows downtime per month, with a replica what-if for the MCP server.
API Polling vs Webhook Call Budget Calculator
Quantifies how many API calls a polling loop burns versus event delivery, and the latency you trade for it.
WhatsApp Business API Cost Calculator
Model monthly WhatsApp cost by marketing, utility and authentication volume with your own rates, free window share and provider fees.
Messaging Throughput and Rate Limit Headroom Calculator
Estimate peak message rate, how much headroom you have under a rate limit, how many workers you need and how long a burst takes to drain.
Teams Webhook Rate Limit Queue Drain Time Calculator
Calculate how long a burst of alerts takes to drain through a rate limited Teams endpoint, including retries after throttling responses.
Messaging Webhook Retry Backoff Schedule Calculator
Work out how long an exponential backoff retry policy keeps trying before a WhatsApp, Teams or Slack message is parked for review.
EDI Document Size and VAN Kilocharacter Calculator
Estimate characters per X12 document from its structure and project kilocharacters and VAN cost per month.
SQL Server Index Size Estimator Calculator
Estimate how many GB a new nonclustered index will add to your ERP database, and see how fill factor changes the size.
SQL Server Transaction Log Sizing Calculator
Work out how large the transaction log of an ERP database should be, and how log backup frequency changes it.
SQL Server Page Compression Savings Calculator
Estimate the GB, cost and rebuild time of applying page compression to the large tables of an ERP database.
CSV Export File Size and Split Calculator
Estimate the size of an ERP CSV extract and how many files you need to stay under Excel's row limit or an upload size cap.
Reference tables
NetSuite SuiteScript Governance Units by Script Type
A lookup of governance unit limits for each SuiteScript script type and the design guidance that follows from them.
HTTP Status Codes for ERP API Agents Reference
Look up an HTTP status code and see what it usually means on an ERP API and whether an agent should retry, fix the request or escalate.
MCP and JSON-RPC Error Codes Reference
A lookup table of JSON-RPC 2.0 error codes and how an MCP server should signal protocol errors versus tool failures.
WhatsApp Cloud API Error Codes Reference
A searchable lookup of common WhatsApp Business Cloud API error codes, what they mean and the first thing to check.
Slack API Rate Limit Tiers Reference
Searchable table of Slack Web API methods with their rate limit tier and how to handle HTTP 429 responses.
Tesseract Page Segmentation Modes and OEM Reference
Look up every Tesseract page segmentation mode (0 to 13) and OCR engine mode (0 to 3), with notes on which to use for invoices, stamps, labels and single fields.
SQL Server, Oracle, PostgreSQL and MySQL Data Type Mapping Reference
A quick lookup of equivalent data types across four databases, with the gotchas that break ERP migrations.
SQL Server Wait Types Reference for ERP Databases
Searchable lookup of common SQL Server wait types with plain-language meaning, typical cause in an ERP workload and the first thing to check.
SQL Data Type Mapping: SQL Server, Oracle, PostgreSQL, MySQL
Searchable table of equivalent data types across SQL Server, Oracle, PostgreSQL and MySQL, with the gotchas that break ERP data loads.
SQL Isolation Levels and Locking Behavior Reference
Compare isolation levels across SQL Server, Oracle, PostgreSQL and MySQL with what each allows and how it affects ERP reports and postings.
Common OT and ICS Protocol Ports Reference
Default TCP and UDP ports used by industrial protocols and the IT services that sit beside them, with a firewall risk note for each.
Windows Security Event ID Reference for Threat Hunting
The event IDs a small security team should log and alert on, from failed logons and new services to cleared logs and PowerShell script blocks.
Code and query generators
SAP Sales Order ABAP SELECT Generator (VBAK, VBAP, VBFA)
Fill in sales organization, order type and date range to get a ready ABAP report skeleton that joins VBAK and VBAP and reads VBFA.
SAP Sales Order Create BAPI ABAP Generator (BAPI_SALESORDER_CREATEFROMDAT2)
Fill in order type, sales area, customer, material and quantity to get an ABAP skeleton that creates a sales order through the standard BAPI.
SAP ABAP Open Items SELECT Generator
Fill in company code, vendor range and key date to get a ready-to-edit ABAP report that lists open vendor items with an overdue calculation.
SAP ACDOCA SQL Query Generator
Build SQL over ACDOCA for account balances and line items by ledger, company code, fiscal year and period range.
SAP QM Inspection Lot ABAP SELECT Generator
Fill in plant, inspection type and date range and get a ready ABAP SELECT joining the inspection lot table QALS to the usage decision table QAVE.
SAP Quality Notification Pareto SQL Query Generator
Build a SQL query over QMEL and QMFE that lists quality notifications and counts defects by code group and code, ready for a Pareto chart.
SAP QM Usage Decision BAPI Skeleton
An ABAP skeleton for recording an inspection lot usage decision through the standard BAPI, with error handling and a commit only when no error is returned.
ABAP Custom Exception Class Generator
Fill in a class name, message class and attribute and get a ready-to-paste class-based exception with a TRY/CATCH usage example.
ABAP Unit Test Class Generator
Create the skeleton of an ABAP Unit local test class with setup, a happy-path test, a boundary test and an exception test.
ABAP BAPI Return Handling and Commit Generator
Wrap any BAPI call with BAPIRET2 error checking, message text building and a safe commit or rollback.
SAP ABAP AUTHORITY-CHECK Snippet Generator
Fill in an authorization object, activity and organisational field and get a ready ABAP AUTHORITY-CHECK block with error handling.
SAP B1 SQL Query Generator (OITM, ORDR, RDR1)
Fill in a few filters and get a read-only SQL query over OITM, ORDR and RDR1 to paste into the SAP B1 Query Manager.
SAP B1 Service Layer Sales Order JSON Generator
Fill in server, company database, customer and line details to get ready-to-test Login and sales order POST requests for the Service Layer REST API.
SAP Business One Service Layer Request Builder
Fill in host, company and item details and get ready-to-paste Service Layer requests for login, item query, sales order and production order.
SAP Business One DI API Sales Order Code Generator (C#)
Fill in connection and order details to get a C# DI API skeleton that connects, adds a sales order and reports errors.
SAP Configurable Material Selection ABAP Generator
Fill in plant and material type to get an ABAP report that lists configurable materials and counts them by plant.
Oracle EBS SQL Query Generator for Items and WIP Jobs
Build ready-to-run SELECT statements over MTL_SYSTEM_ITEMS_B, WIP_DISCRETE_JOBS and on-hand quantity tables.
Oracle EBS Onhand Quantity SQL Generator
Fill in organization, item pattern and subinventory to get ready-to-run SQL for onhand by lot, onhand versus reservations, and recent transaction history.
Oracle EBS BOM Explosion SQL Generator
Produces multilevel bill of material explosion and where-used SQL for Oracle EBS using hierarchical queries, with organization, item and effectivity inputs.
Oracle EBS Pending Transactions SQL Generator for Period Close
Builds SQL that counts and lists pending, errored and uncosted transactions in inventory and WIP before you close an Oracle inventory accounting period.
Oracle Fusion REST API URL Builder
Fill in host, version and resource to generate a Fusion Cloud REST URL with query parameters and a ready curl command.
JD Edwards SQL Query Generator (Open Sales Order Lines)
Generates a read-only SQL Server query for open JDE sales order lines, with Julian date conversion, implied decimal handling and branch filters.
JD Edwards F0911 General Ledger SQL Generator
Fill in schema, company, ledger type and a Julian date range to get ready-to-run SQL for F0911 detail and an account summary.
JD Edwards F4801 Work Order SQL Generator
Build SQL for open JDE work orders by branch plant, status and date, plus the parts list for one work order.
IBM i (DB2 for i) SQL Data Extraction Script Generator
Generate DB2 for i SQL to inspect a file, count rows, and extract records with Julian date filters for JD Edwards World or other IBM i data.
Db2 for i SQL Services Query Generator
Fill in a library, object type and subsystem and get a set of QSYS2 SQL services queries for sizes, row counts, jobs, locks and user profiles.
SyteLine IDO REST Request Generator
Fill in host, configuration, IDO, properties and filter to get ready-to-use REST calls for loading, updating and invoking methods on SyteLine IDOs.
SyteLine SQL Query Generator for Item, Job and Order Tables
Fill in site, item prefix, job status and date to produce read-only SQL for item master, jobs and open customer order lines.
SyteLine SQL Blocking and Long Running Query Script Generator
Builds read-only SQL Server diagnostic scripts for blocking, head blockers, open transactions and slow requests on a SyteLine database.
SyteLine Custom Table CREATE Script Generator
Creates a SQL Server CREATE TABLE script for a custom SyteLine table that follows the standard column and key conventions.
Infor VISUAL SQL Query Generator for Work Orders
Build a SQL Server query for open or late VISUAL work orders by filling a few fields, then copy it into your query tool.
VISUAL SQL to CSV PowerShell Export Script Generator
Fill in server, database, query and folder to get a ready PowerShell script that exports VISUAL data to a dated CSV for scheduling.
Infor XA DB2 for i SQL Extract Generator
Fill in library, file, columns and filter to get a limited SELECT, a row count check and a CPYTOIMPF command to produce a CSV.
Business Central AL Extension Skeleton Generator
Fill in publisher, prefix and ID range to get app.json, a table extension, a page extension, an event subscriber codeunit and a permission set.
Business Central AL Event Subscriber Generator
Builds an AL subscriber codeunit for any published event, with the correct attribute syntax and a procedure stub to fill in.
Business Central OAuth Token Request Generator
Builds the client credentials token request for Business Central online plus sample REST and OData calls using the returned token.
NetSuite SuiteScript 2.1 RESTlet Skeleton Generator
Fill in a script name, record type and fields to get a SuiteScript 2.1 RESTlet with GET lookup, POST create, logging and error handling.
Acumatica REST API URL Builder
Generate contract-based REST URLs and the login call for any Acumatica entity, with $filter, $select, $expand, $top and $skip filled in for you.
Acumatica Sales Order REST JSON Template
Generate the PUT request URL and JSON body to create a sales order with two lines through Acumatica's contract-based REST API.
Acumatica OData Generic Inquiry URL Builder
Generate the OData URL for an Acumatica generic inquiry, with $filter, $select, $orderby and $top, ready for Excel, Power BI or a script.
Acumatica REST API Python Script Generator
Produce a ready-to-run Python script for the Acumatica contract-based REST API: login, PUT a record, then logout.
Sage Intacct XML readByQuery Request Generator
Build a ready-to-post XML request for the Sage Intacct web services gateway using readByQuery with your object, fields, query and page size.
IFS Cloud Projection OData URL Builder
Fill in host, realm, projection and entity set to generate the token request and a ready OData GET URL for IFS Cloud projections.
QAD Progress 4GL Query Generator
Fill in domain, site and a part prefix to get ready-to-run, read-only Progress 4GL queries against common QAD EE tables.
QAD Progress Connection Parameter File Generator
Generate .pf parameter files for connecting a Progress client to a remote QAD database over TCP.
IFS Applications Oracle SQL Query Generator
Fill in site and part to get read-only Oracle SQL against common IFS Applications views for shop orders, stock and customer orders.
Job Shop WIP and Late Jobs SQL Query Generator
Fill in your table and column names and get ready-to-run SQL for open jobs, late jobs and hours variance.
Odoo XML-RPC BOM Export Python Script Generator
Fill in your Odoo URL, database and filters to get a ready Python script that exports BOMs and component lines to a CSV file.
ERPNext REST API BOM and Stock Query Generator
Build ERPNext REST requests with correct filters and fields for BOMs, stock bins and work orders, ready to paste into curl or Postman.
Katana MRP API Request Builder for Orders and Inventory
Build Katana Open API GET requests for sales orders, manufacturing orders, products and inventory, as curl commands or a Python snippet.
Tally TDL Report Template Generator
Generate a starting TDL file with a menu item, collection and report layout so you can customise Tally Prime reports faster.
Tally XML Export Request Generator
Fill a few fields and get a ready XML envelope to pull masters or vouchers from Tally Prime over its HTTP server.
Tally XML Ledger Import Generator
Build the Import Data XML that creates a customer or supplier ledger in Tally Prime with GST details.
GSTIN Validator Code Generator
Get a Python function that checks GSTIN structure, state code and the mod 36 checksum character before you save a party.
China ERP CSV GBK to UTF-8 Converter Script Generator
Generates a ready-to-run Python script that converts CSV files between GBK, GB18030 and UTF-8 so Chinese ERP imports and exports do not turn into garbled text.
China GL Voucher Trial Balance SQL Generator
Builds a trial balance SQL query by account from a voucher line table, with opening, period movement and closing columns.
SYSPRO SQL Query Generator
Generate read-only SQL Server queries against common SYSPRO tables. Fill in database and filters, then copy the code.
Sage Evolution SQL Query Generator for Stock and Debtors
Builds read-only SQL queries for stock items and customer accounts in a Sage Evolution company database.
Exact Online REST API URL Builder
Generate Exact Online REST API GET requests with the right regional host, division, entity and OData-style query options.
Priority ERP OData REST URL Builder
Build Priority ERP OData URLs with host, tenant, company, entity, $filter, $select, $expand and $top, ready to paste into a REST client.
ERP Selection Scoring SQL Generator
Creates the tables and weighted-average query needed to rank ERP vendors from committee scores, ready for SQL Server or PostgreSQL.
ERP Cutover Reconciliation SQL Generator
Fill in your table and column names and get ready-to-run comparison queries for legacy versus new ERP balances.
ERP Migration File Reconciliation Python Script Generator
Generate a pandas script that compares two CSV extracts by key and writes missing, extra and mismatch files.
ERP Duplicate Master Record Finder SQL Generator
Fill in your master table and match columns to get a ready-to-run SQL query that groups likely duplicates for review.
ERP Master Data Completeness Profiling SQL Generator
Enter a table and up to four columns to get SQL that reports null, blank and placeholder rates for each field.
Inventory Aging Buckets SQL Generator
Build an inventory aging query with your own table and column names and bucket sizes, ready to paste into SQL Server style SQL.
ERP KPI Snapshot to Excel Python Script Generator
Fill in your CSV file name and column names to get a short pandas script that computes KPIs and saves a dated Excel snapshot.
Open Production Operations Load SQL Query Generator
Fill in your table and column names and get ready SQL for remaining hours, past due operations and weekly load per work center.
Critical Ratio Dispatch List Python Script Generator
Get a small Python script that turns an ERP export of open operations into a ranked dispatch list by critical ratio.
OEE SQL Query Generator
Fill in your table and column names and get a SQL query that calculates availability, performance, quality and OEE per line per day.
OEE Power BI DAX Measures Generator
Enter your table and column names and get DAX measures for availability, performance, quality and OEE that you can paste into a Power BI model.
Lean KPI SQL Query Generator (OEE Downtime Pareto)
Fill in your own table and column names to get a downtime Pareto query and an availability query you can run against an MES or ERP reporting database.
Python SPC X-bar R and Capability Script Generator
Fill in your CSV column, subgroup size and spec limits to get a ready Python script for X-bar and R limits, Cp, Cpk, Pp and Ppk.
SQL X-bar and R Subgroup Control Limits Query Generator
Generate a SQL query that computes subgroup averages, ranges, control limits and out-of-limit flags from a table of measurements.
Gage R&R Python Script Generator (Average and Range)
Fill in the file name, tolerance, and get a plain Python script that computes the average and range gage R&R.
Calibration Due List SQL Query Generator
Fill in your table and column names and get SQL for overdue, due soon and never-calibrated gages.
FMEA Risk Ranking SQL Query Generator
Generates ANSI-style SQL for an FMEA table: open high-risk lines, overdue actions, risk roll-up by process step and a cumulative Pareto of RPN.
PPAP Status Tracker SQL Query Generator
Fill in your table and column names and get SQL queries for overdue, pending and rejected PPAP submissions by supplier.
X-bar and R Control Limits Python Script Generator
Set subgroup size, spec limits and file name and get a short Python script that computes control limits, Cpk and Ppk from CSV data.
NCR Pareto and Repeat Offender SQL Generator
Fill in your NCR table and column names to get ready-to-run SQL for a defect Pareto with cumulative percent and a repeat offender list.
NCR Pareto Chart Python Script Generator
Fill in your CSV file name and column headers to get a Python script that builds a Pareto chart of nonconformances from an ERP or QMS export.
CAPA Record JSON Payload Generator
Build a clean JSON payload for a corrective and preventive action record to test an API, seed a sandbox or define an integration contract.
Inspection Results SQL Query Generator
Fill in your own inspection table and column names to generate SQL for lot reject rate by supplier and top failing characteristics.
Supplier PPM and On-Time Delivery SQL Query Generator
Fill in your receipt table and column names to generate a ready-to-run SQL query for supplier reject PPM and on-time delivery.
EDI X12 850 Purchase Order Skeleton Generator
Fill in the partner IDs, PO number and one line item to generate a valid-looking X12 850 test message in 005010 format.
SQL Days of Supply and Coverage Query Generator
Fill in your table and column names to produce a days of supply and below-safety-stock SQL query for any relational ERP database.
SQL Monthly Demand History Query Generator
Generate SQL that turns order or shipment lines into a clean monthly demand history per item, with gap months filled with zero.
Python Holt-Winters Forecast Script Generator
Generate a short Python script that fits Holt-Winters to monthly demand, tests it on a holdout against a naive baseline and writes the forecast to CSV.
MRP Net Requirements SQL Generator
Fill in your table and column names and get a SQL query that computes projected available balance and the shortage per item and bucket.
BOM Low Level Code Python Script Generator
Fill in your CSV file and column names and get a Python script that assigns low level codes and flags circular BOMs.
WMS Bin Inventory and Aging SQL Generator
Build starter SQL for stock by bin, aging buckets and mixed-item bins against your own inventory table, in three SQL dialects.
X12 856 Advance Ship Notice Generator
Fill in shipment, carrier and item details and get a clean X12 856 skeleton with shipment, order and item hierarchy to use as a test file.
Late Purchase Order Lines SQL Generator
Generates a SQL query that lists open PO lines past their promise date with days late, plus a roll-up by supplier. Table names are yours to fill in.
X12 850 Purchase Order EDI Skeleton Generator
Builds a single-line ANSI X12 850 purchase order with ISA, GS, ST, BEG, N1 and PO1 segments you can use as a test file or mapping reference.
Fanuc Bolt Hole Circle Macro Generator
Fill in center, radius, number of holes and drill cycle values and get a ready to review Fanuc macro for a bolt hole pattern.
CNC Program Header and Safe Start Block Generator
Create a consistent program header with revision comments, a safe start line and a tool change sequence for a mill.
Sheet Metal BOM to Material Demand Python Script Generator
Generates a ready-to-run Python script that totals blank weight and estimated sheet count per material and thickness from an exported part list.
Sheet Metal Job Cost Rollup SQL Query Generator
Builds a job cost rollup query over generic job, operation and material tables, with your table and column names filled in.
Welding WPS and Welder Register SQL Generator
Fill in table names and the expiry window to get create-table, insert and expiry-report SQL for a welding register.
Molding Scrap and Cycle Time SQL Query Generator
Generate generic SQL for molding scrap rate by tool and press, cycle time against standard, and mold shot-count maintenance alerts.
Foundry Heat Traceability SQL Query Generator
Build SQL that traces a melt heat forward to castings and heat treat loads, or a casting serial back to its heat and chemistry.
Dimensional Inspection Out-of-Tolerance SQL Query Generator
Fill in your inspection results table and column names to get SQL that finds out-of-tolerance measurements and summarizes them by characteristic.
Recursive BOM Explosion SQL CTE Generator
Builds a recursive common table expression that explodes a multi-level BOM with extended quantities, plus a where-used query, using your own table and column names.
Item UoM Conversion Integrity SQL Query Generator
Three read-only SQL checks for missing, invalid and non-reciprocal item UoM conversion factors using your own table and column names.
Excel CONVERT Function Engineering Unit Formula Generator
Fill a cell reference and two unit codes to get ready-to-paste CONVERT formulas, plus a torque conversion since CONVERT has no torque units.
BOM Cost Rollup Recursive CTE SQL Generator
Name your BOM and cost tables and get a recursive SQL query that explodes a bill of material and rolls up purchased component cost.
Excel Timesheet and Overtime Formula Generator
Creates ready-to-paste Excel formulas for night-shift hours, unpaid breaks, rounding, daily and weekly overtime, and gross pay.
Environmental Permit Expiry Alert SQL Generator
Fill in your table and column names and get a ready SQL query that flags environmental permits due for renewal, for SQL Server and PostgreSQL.
Controlled Item Foreign Shipment SQL Query Generator
Fill in your table and column names to get three audit queries that catch unclassified items, controlled items on foreign orders and expired licenses.
Electronic Component Lot Traceability SQL Generator
Fill in your table and column names to get forward trace, backward trace and quarantine-scope SQL for a component lot or date code.
Pick and Place Centroid File Converter Script Generator (Python)
Fill a few fields and get a Python script that reads a centroid CSV, applies offsets and writes a machine ready file.
PCBA BOM Staging Table and Validation SQL Generator
Create a staging table and validation queries to clean an electronic BOM before loading it into an ERP.
Component Shortage SQL Query Generator (Open Demand vs Supply)
Generate a SQL query that compares open demand against on-hand and inbound supply and returns the shortage list for buyers.
BOM Scrub Python Script Generator (Duplicate MPN, Missing RefDes, Qty Mismatch)
Generate a Python script that reads a BOM CSV and reports duplicate MPNs, blank part numbers, missing reference designators and quantity versus refdes count mismatches.
Fiber Optic Test Results SQL Schema and Pass/Fail Query Generator
Creates a table for insertion loss and return loss results and queries that find failures and yield by wavelength.
Gaussian Beam Spot Size and Rayleigh Range Python Generator
Fill in laser wavelength, M-squared, focal length and input beam diameter to generate a ready-to-run Python script for focused spot size and depth of focus.
Photonics Lot Yield and Test Results SQL Query Generator
Generate SQL queries for lot-level first-pass yield, fallout by test step and a defect Pareto using your own table and column names.
Semiconductor Lot Yield and Bin Pareto SQL Generator
Fill in your table and column names to get ready-to-run SQL for weekly yield, bin Pareto and lowest-yield lots.
Western Electric Rules SPC Python Script Generator
Creates a standalone Python script that reads a CSV column and flags points breaking the four Western Electric run rules.
MRO Open Work Order Aging SQL Generator
Builds a SQL query that groups open maintenance work orders into aging buckets so planners can see what is stuck.
MRO Component Removal Record JSON Generator
Creates a clean JSON payload for a component removal or installation event with life counters, reason and traceability fields.
GS1 GTIN Check Digit and UDI Element String Python Generator
Fill in your GTIN base, lot, expiry and serial and get a ready Python script that calculates the check digit and prints the GS1 human readable and encoded strings.
Device Lot Genealogy and Traceability SQL Generator
Build recursive lot genealogy queries for backward trace (finished device to components) and forward trace (component lot to shipped devices) using your own table and column names.
Pharma Batch Genealogy SQL Query Generator
Fill in plant, material and batch to produce SQL for forward and backward batch traces on SAP material documents.
GxP Audit Trail Entry JSON Generator
Build a structured audit trail record with user, time, change, reason and signature meaning for a regulated integration.
Food Lot Traceability SQL Query Generator (Forward and Backward)
Fill in your table and column names to get recursive SQL that traces a lot back to suppliers or forward to customers.
Automotive EDI 830 Planning Schedule Skeleton Generator
Generate a sample ANSI X12 830 planning schedule with release number, ship-to, part and firm and planning forecast lines to test an EDI mapping.
Warranty Claims Pareto and Months in Service SQL Query Generator
Build SQL for a warranty claims Pareto by failure mode and a months-in-service (MIS) distribution from your own claim table.
Installed Base Warranty Expiry SQL Query Generator
Build a T-SQL query that finds machines whose warranty ends within a chosen window, ready for service contract outreach.
Open PO Missing Mill Certificate SQL Generator
Generate SQL that finds material receipts requiring an EN 10204 certificate where no certificate record exists, so quality can chase suppliers.
Apparel Style Color Size SKU Matrix SQL Generator
Generate T-SQL that creates every color and size SKU for a style, skips rows that already exist, and checks the result for duplicates.
SSCC-18 Pallet Shipping Label ZPL Generator
Fill in ship-to, PO, GTIN, quantity and SSCC to get ZPL for a 4 x 6 inch GS1-128 pallet label.
GST E-Invoice JSON Payload Generator
Builds a sample e-invoice JSON with the main IRP blocks so developers can map ERP fields and test in the sandbox.
ERP Item Master HSN and GST Rate Audit SQL Generator
Enter your item master and invoice line table and column names to get SQL that finds blank HSN codes, wrong digit counts, items with several rates and invoice lines that disagree with the master.
GSTR-1 HSN Summary Pandas Script Generator
Name the columns in your ERP invoice line export and get a pandas script that rolls them up into an HSN-wise summary with quantity, value, taxable value and taxes.
China Unified Social Credit Code Validator Script Generator
Generates a Python script that validates the 18-character check digit of Chinese company registration codes in your vendor master export.
ERP Foreign Currency Revaluation SQL Generator
Generates SQL that picks the latest closing rate on or before the revaluation date, revalues open foreign currency items and summarises unrealised gain or loss by currency.
Sales Tax Exemption Certificate Expiry SQL Generator
Fill in your table and column names to get ready-to-run SQL for SQL Server, PostgreSQL and Oracle that lists certificates expiring soon or already expired.
State Sales Nexus CSV Checker Python Script Generator
Configure your CSV column names and threshold to get a small Python script that flags states close to or over your nexus level.
CFDI 4.0 XML Skeleton Generator
Fill in a form and get a CFDI 4.0 XML skeleton with the right nodes and attributes, ready to adapt for test stamping with a PAC.
Mexico CFDI 4.0 Invoice XML Skeleton Generator
Fill in a few fields and get a CFDI 4.0 ingreso XML skeleton to test your ERP mapping or a PAC sandbox request.
IMMEX Temporary Import Balance Aging SQL Generator
Build a SQL query that shows open temporary-import quantities by pedimento line, days to deadline and overdue status, from your own staging tables.
EU VIES VAT Number Validation SOAP Request Generator
Builds the SOAP envelope for the EU VIES checkVat service so you can validate customer and supplier VAT numbers from an ERP job or script.
UK Trade Tariff API Commodity Lookup URL Builder
Generates the Trade Tariff API URL, curl command and Python snippet to pull a commodity code, its duties and import measures into your ERP.
BOM Compliance Declaration Gap SQL Query Generator
Builds a SQL query and a summary query that list BOM components without a current compliance declaration for a chosen regulation.
Component Declaration Status Python Script Generator
Creates a standard-library Python script that reads a BOM export and a declarations export and writes a gap report CSV.
Contract Expiry and Notice Deadline SQL Query Generator
Generate a SQL query that finds contracts expiring soon and the last day to send a non-renewal notice, using your table and column names.
X12 855 Purchase Order Acknowledgment Skeleton Generator
Builds a correctly structured X12 855 PO acknowledgment (ISA through IEA) with BAK, PO1 and ACK loops so you can test with a trading partner.
Excel Open Order Aging and Late Line Formula Generator
Tell it which columns hold your due date, quantities and ship date, and it writes the Excel formulas for days past due, aging buckets, open quantity and OTD flags.
vLLM Docker Compose Generator for a Private ERP LLM
Fill in the model, context length and GPU count to get a docker-compose file that serves an OpenAI-compatible endpoint inside your network.
Ollama Modelfile Generator for an ERP Assistant
Build a Modelfile that bakes a grounded, read-only ERP system prompt and sane parameters into a local Ollama model.
ERP AI Agent Read-Only SQL Server Role Generator
Create a least-privilege SQL Server login and role for an AI agent, with table grants, sensitive column denies and a row filter by site.
MCP Server Tool Definition JSON Generator
Fill in a tool name, description and one parameter to get a valid MCP tool definition with an inputSchema and behavior annotations.
Claude Desktop MCP Config JSON Generator
Build the mcpServers entry for claude_desktop_config.json with the right command, arguments and environment variables.
OpenAPI Spec Skeleton Generator for ERP Endpoints
Create an OpenAPI 3.0 YAML starting point for an ERP resource with list and get operations, paging and a record schema.
Webhook Payload Template Generator
Design a consistent JSON webhook payload for ERP events, with an idempotency id, versioning and signature header guidance.
ERP Record JSON Schema Generator
Define an item, order or supplier record as JSON Schema with types, patterns, enums and required fields for validation and AI tool input.
Idempotent ERP API Retry Wrapper Python Generator
Fill in your header names and limits to get a Python function that retries safely with backoff and sends an idempotency key on writes.
Webhook HMAC Signature Verification Node.js Generator
Create an Express endpoint that checks the HMAC of the raw body, rejects stale timestamps and acknowledges quickly for ERP event webhooks.
Paginated OData Fetch Loop Python Generator
Build a Python loop that follows nextLink pages from an OData entity set and writes the result to CSV with a hard row cap.
ERP MCP Server Python Tool Skeleton Generator
Get a runnable Python MCP server with one read-only ERP lookup tool, argument validation and errors that the model can understand.
Agent SQL Read-Only Guard Python Generator
Add a first line of defense before agent-written SQL reaches an ERP database: single statement, SELECT only, allow-listed tables and a row cap.
WhatsApp Template Message Builder
Generates the JSON to create a WhatsApp message template and the JSON to send it, with header, body variables, footer and a quick reply button.
Teams Adaptive Card JSON Generator for Approvals
Creates an Adaptive Card approval message with a fact set, comment input and Approve and Reject actions, wrapped for a Teams webhook or Workflows post.
Slack Block Kit Approval Message Generator
Creates a chat.postMessage body with Block Kit sections, fields and Approve and Reject action buttons for ERP approval workflows.
Webhook Signature Verification Code Generator
Generates an Express.js webhook endpoint with the Meta GET verification handshake and constant time HMAC SHA256 signature checks.
WhatsApp Cloud API Send Template Request Generator
Builds the Graph API request, JSON payload and a Python equivalent for sending an approved template with up to three body variables.
ERP Event Messaging Outbox Table SQL Generator
Creates outbox table DDL, an insert example and a safe worker claim query so ERP events reach messaging channels exactly once in practice.
Tesseract OCR Command Line Generator
Build the exact tesseract command for a single file and a PowerShell loop for a whole folder, with language, page segmentation mode, resolution and output format set from a form.
Invoice Field Regex Generator (Python)
Set the labels your suppliers use and get a Python script with regexes for invoice number, PO number, invoice date and total amount, plus a total check.
Invoice Extraction JSON Schema Generator
Create a JSON Schema that defines and validates the structure of extracted invoice data, including header fields, line items, confidence scores and review flags.
X12 ISA GS Envelope Skeleton Generator
Fill in sender, receiver, qualifiers and control numbers and get a matching envelope to test a translator or a partner connection.
SQL Date Range Filter Generator
Builds a correct half-open date range WHERE clause for four SQL dialects, so month-end and timestamp reports stop dropping the last day.
ERP Data Extract PowerShell to CSV Script Generator
Creates a scheduled-task-ready PowerShell script that runs a read-only SQL query and writes a timestamped CSV with a simple log.
Excel to SQL INSERT Statement Generator
Build INSERT statements from spreadsheet rows, with an Excel formula that creates the value lists and a rollback-safe wrapper.
ERP Incremental Extract Watermark SQL Generator
Generate a T-SQL script that pulls only new and changed ERP rows using a watermark control table.
SQL Running Total and Window Function Query Generator
Fill in your table and column names to get running total, previous-row change and top-N per group queries using window functions.
SQL Server Blocking and Deadlock Diagnostic Script Generator
Generate T-SQL to list blocked sessions, find the head blocker and its SQL text, spot idle open transactions and read recent deadlock graphs.
SQL Monthly Pivot Query Generator (Conditional Aggregation)
Build a month-by-month cross-tab of any ERP amount, such as usage by item or sales by customer, using portable CASE and SUM logic.
SQL Server ERP Backup Script Generator
Fill in the database name, backup folder and retention to get a T-SQL script with checksum, compression, verification and backup history cleanup.
Active Directory Stale Account Report PowerShell Generator
Generate a PowerShell script that finds inactive AD users and computers and accounts with non-expiring passwords, then exports the results to CSV for an access review.
SIEM Failed Logon Detection KQL Query Generator
Fill in a time window and thresholds and get ready-to-paste KQL for Microsoft Sentinel or Log Analytics covering password guessing and common tampering events.
PowerShell Windows Host Security Audit Script Generator
Produce a read-only script that gathers local administrators, listening ports, installed updates and scheduled tasks from a list of servers into CSV files.
Plant Monthly Business Review SQL Generator
Fill in schema and table names and get four SQL queries for monthly review KPIs: on-time delivery, scrap rate, aged WIP and completed units by week.
Checklists
Messaging Integration Go Live Readiness Checklist
A launch checklist for ERP to WhatsApp, Teams or Slack integrations covering consent, throughput, failure handling, monitoring and support.
ERP Database Health Check Checklist
A quarterly checklist for the database under your ERP: recovery, integrity, performance, capacity, security and operations.
Assessments
ERP Agent API Integration Readiness Assessment
Answer ten questions about APIs, roles, limits and logging to see whether your ERP is ready for an AI agent or MCP integration.
ERP Reporting Query Quality Assessment
Answer 10 questions about how your team writes, tests, documents and runs SQL reports on ERP data, and get a score with recommendations.