dbtools

Apr 24, 2025

Changes in this version

+ func GetDatabaseQueryTimeout(db db.Database) int

+ func RegisterMCPDatabaseTools(registry *tools.Registry) error

Apr 11, 2025

Changes in this version

+ type DatabaseStrategy interface

+ GetColumnsQueries func(table string) []queryWithArgs

+ GetRelationshipsQueries func(table string) []queryWithArgs

+ GetTablesQueries func() []queryWithArgs

+ func NewDatabaseStrategy(driverName string) DatabaseStrategy

+ type GenericStrategy struct

+ func (s *GenericStrategy) GetColumnsQueries(table string) []queryWithArgs

+ func (s *GenericStrategy) GetRelationshipsQueries(table string) []queryWithArgs

+ func (s *GenericStrategy) GetTablesQueries() []queryWithArgs

+ type MySQLStrategy struct

+ func (s *MySQLStrategy) GetColumnsQueries(table string) []queryWithArgs

+ func (s *MySQLStrategy) GetRelationshipsQueries(table string) []queryWithArgs

+ func (s *MySQLStrategy) GetTablesQueries() []queryWithArgs

+ type PostgresStrategy struct

+ func (s *PostgresStrategy) GetColumnsQueries(table string) []queryWithArgs

+ func (s *PostgresStrategy) GetRelationshipsQueries(table string) []queryWithArgs

+ func (s *PostgresStrategy) GetTablesQueries() []queryWithArgs

Mar 25, 2025

Changes in this version

+ func GetTransaction(id string) (*sql.Tx, bool)

+ func RemoveTransaction(id string)

+ func StoreTransaction(id string, tx *sql.Tx)

+ func StripComments(input string) string

+ type Config struct

+ ConfigFile string

+ Connections []ConnectionConfig

+ type ConnectionConfig struct

+ Host string

+ ID string

+ Name string

+ Password string

+ Port int

+ Type DatabaseType

+ User string

type DatabaseConnectionInfo

+ Name string

+ type MultiDBConfig struct

+ Connections []ConnectionConfig

type PerformanceAnalyzer

+ func (pa *PerformanceAnalyzer) GetSlowThreshold() time.Duration

+ func (pa *PerformanceAnalyzer) LogSlowQuery(query string, params []interface{}, duration time.Duration)

+ type QueryRecord struct

+ Duration time.Duration

+ Error string

+ Optimized bool

+ Params []interface{}

+ Query string

+ StartTime time.Time

+ Suggestion string

+ type SQLIssueDetector struct

+ func NewSQLIssueDetector() *SQLIssueDetector

+ func (d *SQLIssueDetector) AddPattern(name, pattern string)

+ func (d *SQLIssueDetector) DetectIssues(query string) map[string]string

Mar 25, 2025

Changes in this version

+ func ListDatabases() []string

+ func PingDatabase(db *sql.DB) error

+ type Condition struct

+ Column string

+ Connector string

+ Operator string

+ Value string

+ type DatabaseConnectionInfo struct

+ Database string

+ Host string

+ ID string

+ Latency string

+ Port int

+ Status string

+ Type DatabaseType

+ type JoinClause struct

+ On string

+ Table string

+ Type string

+ type OrderBy struct

+ Column string

+ Direction string

+ type QueryComponents struct

+ From string

+ GroupBy []string

+ Having []string

+ Joins []JoinClause

+ Limit int

+ Offset int

+ OrderBy []OrderBy

+ Select []string

+ Where []Condition

Mar 22, 2025

Changes in this version

+ func AnalyzeQuery(query string) []string

+ func InitPerformanceAnalyzer()

+ type PerformanceAnalyzer struct

+ func GetPerformanceAnalyzer() *PerformanceAnalyzer

+ func NewPerformanceAnalyzer() *PerformanceAnalyzer

+ func (pa *PerformanceAnalyzer) Disable()

+ func (pa *PerformanceAnalyzer) Enable()

+ func (pa *PerformanceAnalyzer) GetAllMetrics() []*QueryMetrics

+ func (pa *PerformanceAnalyzer) GetSlowQueries() []*QueryMetrics

+ func (pa *PerformanceAnalyzer) Reset()

+ func (pa *PerformanceAnalyzer) SetSlowThreshold(threshold time.Duration)

+ func (pa *PerformanceAnalyzer) TrackQuery(ctx context.Context, query string, params []interface{}, ...) (interface{}, error)

+ type QueryMetrics struct

+ AvgDuration time.Duration

+ Count int

+ LastExecuted time.Time

+ MaxDuration time.Duration

+ MinDuration time.Duration

+ Query string

+ TotalDuration time.Duration

Mar 19, 2025

Changes in this version

+ func RegisterMockDatabaseTools(registry *tools.Registry)

+ func RegisterSchemaExplorerTool(registry *tools.Registry)

Mar 17, 2025

Changes in this version

+ func BeginTx(ctx context.Context, db Database, opts *sql.TxOptions) (*sql.Tx, error)

+ func CloseDatabase() error

+ func Exec(ctx context.Context, db Database, query string, args ...interface{}) (sql.Result, error)

+ func GetDatabase() db.Database

+ func InitDatabase(cfg *config.Config) error

+ func Query(ctx context.Context, db Database, query string, args ...interface{}) (*sql.Rows, error)

+ func QueryRow(ctx context.Context, db Database, query string, args ...interface{}) *sql.Row

+ func RegisterDatabaseTools(registry *tools.Registry)

+ type Database interface

+ BeginTx func(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ Exec func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ Query func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRow func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type DatabaseType string

+ const MySQL

+ const Postgres