# Custom extension for Databases

**URL:** <https://community.dynatrace.com/t/custom-extension-for-databases/45089>\
**Category:** Extensions\
**Tags:** databases, oracle, extensions\
**Created:** [April 11, 2024, 12:16am UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089 "2024-04-11T00:16:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![nikhil](https://avatars.discourse-cdn.com/v4/letter/n/b782af/32.png) [@nikhil](https://community.dynatrace.com/u/nikhil)\
**Post date:** [April 11, 2024, 12:16am UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/1 "2024-04-11T00:16:21Z")

</div>

hi all,

I am new to dynatrace and working on custom query extension. I want&nbsp; SQL query to execute at 1min interval and provide the metrics. From VS code i deployed the custom extension. Beyond that what is the format to add query to yaml file and start monitoring ?

requirement:

need to get the metrics for following SQL query

select \* from (select sql\_text, elapsed\_time/1000000 from sys.v\_$sqlarea order by 2 desc) where rownum \< 21;

Please help me out. Thanks

---

<div class="post-metadata">

**Author:** ![nikhil](https://avatars.discourse-cdn.com/v4/letter/n/b782af/32.png) [@nikhil](https://community.dynatrace.com/u/nikhil)\
**Post date:** [April 11, 2024, 12:19am UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/2 "2024-04-11T00:19:37Z")

</div>

If someone has the custom query extension yaml file with SQL query monitored, pls provide to use it as template

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [April 11, 2024, 6:41am UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/3 "2024-04-11T06:41:07Z")

</div>

Hi,

You have a [SQL data source reference](https://docs.dynatrace.com/docs/shortlink/sql-reference). It might be helpful.

Best regards

---

<div class="post-metadata">

**Author:** ![PacoPorro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pacoporro/32/36087_2.png) [@PacoPorro](https://community.dynatrace.com/u/PacoPorro)\
**Post date:** [April 11, 2024, 6:44am UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/4 "2024-04-11T06:44:07Z")

</div>

Have you tried the doc skeleton?

> **[SQL data source reference](https://docs.dynatrace.com/docs/ingest-from/extensions/develop-your-extensions/data-sources/sql/sql-reference)**
>
> Learn about SQL extensions in the Extensions framework.

---

<div class="post-metadata">

**Author:** ![Mike\_L](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mike_l/32/11717_2.png) [@Mike\_L](https://community.dynatrace.com/u/Mike_L)\
**Post date:** [April 11, 2024, 7:24am UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/5 "2024-04-11T07:24:16Z")

</div>

On top of the other links people already shared, I recommend this video for a step by step guide:

[![](https://global.discourse-cdn.com/dynatrace/original/3X/4/e/4eb12e9e93fd0cdedcd07d59496499a7c7c7ab77.jpeg "A Practical Guide to SQL Extensions with Dynatrace") ](https://www.youtube.com/watch?v=t9kHPKL9yKY)

---

<div class="post-metadata">

**Author:** ![nikhil](https://avatars.discourse-cdn.com/v4/letter/n/b782af/32.png) [@nikhil](https://community.dynatrace.com/u/nikhil)\
**Post date:** [April 11, 2024, 12:12pm UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/6 "2024-04-11T12:12:00Z")

</div>

Thank you all, got exactly what I wanted.

---

<div class="post-metadata">

**Author:** ![Esam\_Eid](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/esam_eid/32/167_2.png) [@Esam\_Eid](https://community.dynatrace.com/u/Esam_Eid)\
**Post date:** [April 11, 2024, 12:12pm UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/7 "2024-04-11T12:12:13Z")

</div>

![Screenshot_1.jpg](https://global.discourse-cdn.com/dynatrace/original/3X/2/d/2d8f96c580a03b094b3f22c9f13cfd06abdd3f38.jpeg)

---

<div class="post-metadata">

**Author:** ![wwangwrk](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@wwangwrk](https://community.dynatrace.com/u/wwangwrk)\
**Post date:** [June 25, 2025, 5:14pm UTC](https://community.dynatrace.com/t/custom-extension-for-databases/45089/8 "2025-06-25T17:14:42Z")

</div>

Is it possible to define a variable for the interval (10 minutes) and use it in the query?
