skills.rest
abdullah1854
abdullah1854COMMUNITY
Explore all skills by this author →
GitHub

ax-dynamics-helper

Generate Dynamics AX SELECT queries with DATAAREAID filtering for core tables.

1|Updated Dec 22, 2025
Search Tags:#database#erp#dynamics#ax
One-click install
npx skills add https://github.com/abdullah1854/ClaudeSuperSkills --skill ax-dynamics-helper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ax-dynamics-helper
Source: https://github.com/abdullah1854/ClaudeSuperSkills/tree/main/ax-dynamics-helper
Command: npx skills add https://github.com/abdullah1854/ClaudeSuperSkills --skill ax-dynamics-helper

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires typing, sys, and includes scripts (resource) components.

What problem does it solve?

Generates robust MS Dynamics AX queries with standard DATAAREAID filtering for core AX tables.

Core Features & Use Cases

  • Table Templates: Predefined AX tables and schemas.
  • Join & Filter: Simple joins with DATAAREAID filtering.
  • Guidance: Default filters plus optional additional clauses.

Quick Start

Generate a top-N SELECT for a given AX table with optional DATAAREAID.

Frequently Asked Questions about ax-dynamics-helper

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate Dynamics AX queries with DATAAREAID filtering?▼

This Skill generates SELECT statements for AX tables like SALESTABLE, SALESLINE, PURCHTABLE, PURCHLINE, INVENTTABLE, CUSTTABLE, and VENDTABLE with automatic DATAAREAID filtering, TOP 100 limits, and optional column schemas to produce executable query strings.

Can I use predefined schemas when querying Dynamics AX tables?▼

Yes, the Skill implements dynamic column selection from predefined schemas for core AX tables, letting you customize which columns appear in generated SELECT statements without manual query construction.

What tables does this Skill support for Dynamics AX queries?▼

The Skill provides templates for SALESTABLE, SALESLINE, PURCHTABLE, PURCHLINE, INVENTTABLE, CUSTTABLE, and VENDTABLE with built-in joins and DATAAREAID filtering tailored to each table's schema.

How do I output Dynamics AX queries for REST API or MCP Gateway use?▼

The Skill generates executable query strings formatted for compatibility with MCP Gateway or REST API endpoints, requiring only table selection and optional DATAAREAID parameter input.

Do I need to manually write DATAAREAID filters for AX table queries?▼

No, the Skill applies standard DATAAREAID filtering automatically to all generated queries, with optional configuration for additional filter clauses beyond the default criteria.

Related Skills

Explore More Data & Analytics Skills→
tecnologia-ibtechtecnologia-ibtech

metabase-schema

Explore Metabase-connected database schemas, tables, and field metadata.

Community
Intermediate
adologyaiadologyai
2

data-explorer

Query and refine Adology content with filters and export to CSV, JSONL, or TXT.

Official
Advanced
Rwb3nRwb3n
1

schema-ref

Validate the haios_memory schema before executing SQL queries.

Community
Basic
GDSDNGDSDN
3

db-schema-audit

Audit PostgreSQL database schemas for quality, performance, security, and integrity issues.

Community
Advanced