registry / @mastra/mssql / 1.4.1

@mastra/mssql@1.4.1

MSSQL provider for Mastra - db storage capabilities

Static Scan Results

scanned 19d ago · by rust-scanner

Static analysis completed at 65.0% confidence. No malicious behavior was detected; 6 low-signal pattern(s) were surfaced and cleared.

Static reason

No blocking static signals were detected.

Decision evidence

public snapshot

Behavioral surface

Source

Crypto

Supply chainNo supply-chain packaging signals triggered.

ManifestNo manifest risk signals triggered.

scanned 2 file(s), 369 KB of source

Source & flagged code

5 flagged

dist/docs/references/reference-storage-mssql.mdView file

Lines 59-109markdown

59 id: 'mssql-storage-1',

60 connectionString:

61 'Server=localhost,1433;Database=mydb;User Id=sa;Password=password;Encrypt=true;TrustServerCertificate=true',

62})

64// Using a connection string with a custom schema name

65const store2 = new MSSQLStore({

66 id: 'mssql-storage-2',

67 connectionString:

68 'Server=localhost,1433;Database=mydb;User Id=sa;Password=password;Encrypt=true;TrustServerCertificate=true',

69 schemaName: 'custom_schema', // optional

70})

72// Using individual connection parameters

73const store4 = new MSSQLStore({

74 id: 'mssql-storage-3',

75 server: 'localhost',

76 port: 1433,

77 database: 'mydb',

78 user: 'user',

79 password: 'password',

Medium

Secret Pattern

Hardcoded password in dist/docs/references/reference-storage-mssql.md

dist/docs/references/reference-storage-mssql.mdView on unpkg · L79

80})

82// Individual parameters with schemaName

83const store5 = new MSSQLStore({

84 id: 'mssql-storage-4',

85 server: 'localhost',

86 port: 1433,

87 database: 'mydb',

88 user: 'user',

89 password: 'password',

Medium

Secret Pattern

Hardcoded password in dist/docs/references/reference-storage-mssql.md

dist/docs/references/reference-storage-mssql.mdView on unpkg · L89

90 schemaName: 'custom_schema', // optional

91})

92```

94## Additional notes

96### Schema Management

98The storage implementation handles schema creation and updates automatically. It creates the following tables:

100- `mastra_workflow_snapshot`: Stores workflow state and execution data

101- `mastra_evals`: Stores evaluation results and metadata

102- `mastra_threads`: Stores conversation threads

103- `mastra_messages`: Stores individual messages

104- `mastra_traces`: Stores telemetry and tracing data

105- `mastra_scorers`: Stores scoring and evaluation data

106- `mastra_resources`: Stores resource working memory data

107

108### Initialization

109

dist/storage/index.d.tsView file

Lines 65-105typescript

65 * { name: 'my_threads_type_idx', table: 'mastra_threads', columns: ['JSON_VALUE(metadata, \'$.type\')'] },

66 * ],

67 * });

68 * ```

README.mdView file

Lines 25-65markdown

26```typescript

27import { MSSQLStore } from '@mastra/mssql';

29const store = new MSSQLStore({

30 id: 'mssql-storage',

Source & flagged code

5 flagged · loading source

dist/docs/references/reference-storage-mssql.mdView file

79patternName = generic_password severity = medium line = 79 matchedText = password...rd',

Medium

Secret Pattern

Hardcoded password in dist/docs/references/reference-storage-mssql.md

Static Scan Results

Decision evidence

Source & flagged code

Source & flagged code

Findings

Source & flagged code