Rapid7 Vulnerability & Exploit Database

MSSQL Schema Dump

Back to Search

MSSQL Schema Dump



This module attempts to extract the schema from a MSSQL Server Instance. It will disregard builtin and example DBs such as master, model, msdb, and tempdb. The module will create a note for each DB found, and store a YAML formatted output as loot for easy reading.


  • theLightCosine <theLightCosine@metasploit.com>


Module Options

To display the available options, load the module within the Metasploit console and run the commands 'show options' or 'show advanced':

msf > use auxiliary/scanner/mssql/mssql_schemadump
msf auxiliary(mssql_schemadump) > show actions
msf auxiliary(mssql_schemadump) > set ACTION < action-name >
msf auxiliary(mssql_schemadump) > show options
    ...show and set options...
msf auxiliary(mssql_schemadump) > run 

Time is precious, so I don’t want to do something manually that I can automate. Leveraging the Metasploit Framework when automating any task keeps us from having to re-create the wheel as we can use the existing libraries and focus our efforts where it matters.

– Jim O’Gorman | President, Offensive Security